Test if a year is a leap year


 A
1=TODAY() = 01/03/2023
2=NOW() = 3/1/2023 6:00
3=MONTH(DATE(YEAR(A1),2,29))=2 = 0

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


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