Date Formula Required Pls

[Arts]

Hi all

I have a list of dates and column headers as below, what I am hoping to achieve is if the "Actual End Date" column is blank I would like to insert today's date but if today's date is entered and if today's date is past the Due date I would like it to say "No Actual End Date Entered - Past Date". (Expected Results showing desired outcome)

Is it possible to have the TODAY function in an IF statement and then return what I have in the Expected Results Column

Where both due date and Actual End Date have a value this is fairly straight forward =IF(D6<C6,"On Time", "Past Date") but struggling to incorporate the TODAY function within this and then giving the result of "No Actual End Date Entered - On Time" or "No Actual End Date Entered - Past Date"

Due Date	Actual End Date	Result	Expected Result
29/03/2024​			No Actual End Date Entered - On Time
05/07/2023​			No Actual End Date Entered - Past Date
25/03/2023​	25/02/2023​	On Time	On Time

Appreciate any help as always.

 

[Joe4]

Try this:

=IF(D6<>"",IF(D6<=C6,"On Time", "Past Date"),IF(C6<TODAY(),"No Actual End Date Entered - Past Date","No Actual End Date Entered - On Time"))

 

[Arts]

That is so irksome when you guys do that , I think I said this to you once before when you helped me on an COUNTIF formula. I had spent close to an hour going nuts over this before waving the white flag. I was trying =IF(D4="",IF(D4(TODAY()<C4,, and all sorts....

Always trips me putting the second if in the TRUE part rather than the FALSE

Thanks Joe!!

 

[Joe4]

You are welcome.
Glad I was able to help!