Test if a year is a leap year


 A
1=TODAY() = 04/06/2026
2=NOW() = 6/4/2026 10:35
3=MONTH(DATE(YEAR(A1), 2, 29))=2 = 0

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

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