IF Formula with dates

[lenahanr]

In cell a1 I have a date. In cell b1, I want the date from A1 to be entered only if it's in the future. If it's in the past, I would like to have 'Complete" entered. If have tried a bunch of if/then stuff but am getting confused with the <today function, if that is even the right one.

Thanks in advance, this board is great once lost!

rob

 

[Aladin Akyurek]

In cell a1 I have a date. In cell b1, I want the date from A1 to be entered only if it's in the future. If it's in the past, I would like to have 'Complete" entered. If have tried a bunch of if/then stuff but am getting confused with the <today function, if that is even the right one.

Thanks in advance, this board is great once lost!

rob

=IF(A1 > TODAY(), A1, "Complete")

 

[HalfAce]

Hello lenahanr.
Is this what you had in mind?

=IF(A1>TODAY(),A1,"Complete")

Hope it helps.

 

[lenahanr]

That's ot, thanks a bunch!