Putting the word Complete in a cell-based on another cell that has a date(no specific date)

[Stephpotter]

This has most likely already been answered, but I am trying to figure out how to write 'Complete' in a cell based on the date in another cell. The date will either be today's date or before it.

I have tried multiple ways but nothing has been working for me.

I am more than happy to use formula, conditional formatting or even VBA.

Thanks for your help guys!

 

[Fluff]

Maybe

=IF(A2<>"","Complete","")

or

=IF(A2<=TODAY(),"Complete","")

 

[Stephpotter]

Thankyou!! Worked great!

 

[Fluff]

You're welcome & thanks for the feedback.

 

[Stephpotter]

It works but it makes all my cells turn to complete instead of just the ones with the dates in as the others are blank

 

[Fluff]

If you want the Completed added to a cell if another cell is not blank, then use the 1st formula

 

[Stephpotter]

If you want the Completed added to a cell if another cell is not blank, then use the 1st formula

Thankyou! Worked like a dream!

 

[Fluff]

You're welcome & thanks for the feedback.