Date Value Error

Copper Contributor

I have this data table that I want numbers from basically each day of the month to give me data for specific things. Everything works and it is all okay, except when i try to set the date to anything greater than 28. So an example, 2/28/2023 and the formulas work perfectly, now if I try to use 2/29/2023 it gives me #VALUE! error. How would I be able to fix this? 

1 Reply


2023 is not a leap year, so Excel does not recognize 2/29/2023 as a valid date. Hence, the DAY function causes an error.