Forum Discussion
Hattsoff
Sep 19, 2019Copper Contributor
Leap year formula
Over the years I've run into several situations where we've needed to determine if the year is a leap year; most recently to determine the number of working days to calculate billable time - not the ...
Twifoo
Sep 19, 2019Silver Contributor
Another alternative is:
=IF(DAY(DATE(YEAR(A1),3,0))=29,
“Leap”,”No”)
=IF(DAY(DATE(YEAR(A1),3,0))=29,
“Leap”,”No”)