Forum Discussion

udaya1602's avatar
udaya1602
Copper Contributor
Jun 14, 2023
Solved

days count

Using this formula (=DATEDIF(TODAY(),H4,"d"))  to count the days left from the date mentioned in H4. if a value is feeded in H4 it is fine. but when H4 is empty it show num error(#NUM!).. 
excel
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Jun 14, 2023

udaya1602 Try this:

=IFERROR(DATEDIF(TODAY(),H4,"d"),"")