Test if a year is a leap year

	A
1	=TODAY() = 01/07/2024
2	=NOW() = 7/1/2024 6:51
3	=MONTH(DATE(YEAR(A1), 2, 29))=2 = -1

Test if a month has 31 days
Test if a month has 30 days

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top