Date countdown

[west813]

Hi
I am using this formula to count down from present date to a future date =DATEDIF(B4,J6,"D") B4 =TODAY() J6 entered date 1/20/2016
return 270 days in K6. My problem is when it gets below 1 it return #NUM! i need to return 0 when it goes -.
Any help much appericated.

[skywriter]

Please Login or Register  to view this content.

[west813]

Skywriter
Thank you very much for you help.

[skywriter]

Skywriter
Thank you very much for you help.

My pleasure.


If your original request is fulfilled please click the Thread Tools drop down box above your first post and choose solved.