I did a calc sheet with dates and a cell telling how much days it reminds before it expires.
I would like to get rid of the Err:XXX when no value or nothing to calculate and i would like to get a blank cell instead of a XX/XX/00 date in my expirations cells.
I have my alert date let’s say today 04/04/2019 (date fixed value)
My Reminder/timer which is done like this : =“Reminds” & " " & DATEDIF(TODAY();L4;“d”) & " " & “days”
And L4 is my expiration date calcultated with +15 days like that : C*+15
The only tips i have found would be IF or IFERROR etc. but most of anwsers are for regular calculations with no dates.
Any advices ?