I am using the today() to count down days

=IF(B10=0,"days left",B10-TODAY())

but when i enter the date in (any date) to b10 is tell me "The date you entered is before the current date of today. you must enter a date after today"

i tried the use now() ,but the same thing happens.

what gives???


OP