Error with checking current and past dates formula

[BlissC]

Hi everyone,

I'm probably missing something blindingly obvious here, but I'm trying to use a formula to check whether a date's in the past or is a current or future date, but if there's no date recorded in the cell in question to return a blank cell in the cell containing the formula.

This is the formula I'm trying to use:

=IF($C13>=NOW(),"Current records",IF($C13<NOW(),"Past records",IF(ISBLANK($C13),"")))

It works in that it returns "past records" if the date's in the past and "current records" if the date's a current or future date, but if the cell's empty (i.e. doesn't contain a date), the formula's still returning "past records" even though there's no date. I've tried all sorts of variations, including using three IF statements to check for each condition but not only did that not work, but Excel kept telling me I had too many arguments. This one using ISBLANK with the IF statements is the only variation I've managed to get to work returning past or current records, but I can't get the 'no date' condition working.

I'd be very grateful if anyone could point me in the direction of where I'm going wrong.

Many thanks,

Bliss

 

[Muhammad_Usman]

Why you are not using Today() function instead of Now() if you only looking for dates

 

[Fluff]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

How about

=IF($C13="","",IF($C13>=TODAY(),"Current records","Past records"))

 

[BlissC]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

How about

=IF($C13="","",IF($C13>=TODAY(),"Current records","Past records"))

Thank you so much. That's working perfectly. (and yes, I'll update my account details).

Thanks again,

Bliss

 

[Fluff]

Glad we could help & thanks for the feedback.