If(leap year) formula

[Tjfinley]

I apologize for the many tabs. Most of my formulas and formatting are connected to the previous tab/Jun-Jul tab). I am working in tab Feb-Mar & Mar-Apr. I have created a IF LEAP YEAR formula that works great when my WORKSHEET is 2023-2024 but when it is a non leap year, the formula doesn't display " ". I have tried swapping my [value_if_true] & [value_if_false] criteria. That works for a non-leap year but not 2024. What am I doing wrong?

The timesheet dates go from 16th-15th.

I am working in cells (highlighted in RED):

Feb-Mar: B37 & B38
Mar-Apr: C8

[Pete_UK]

Change the formula in C36 of the Feb-Mar sheet to this:

=IF(MONTH(DATE(YEAR(C8),2,29))=2,SUM(C35+1),"")

and change C8 of the Mar-Apr sheet to this:

=IF(MONTH(DATE(YEAR('Feb-Mar'!C8),2,29))=2,SUM('Feb-Mar'!C36+1),SUM('Feb-Mar'!C35+1))

Hope this helps.

Pete

[Tjfinley]

Thank you Pete. That fixed my problem. Glad it was a simple fix.

Hope you have a great day!

[Pete_UK]

Glad to help - thanks for the rep.

Pete