Hi all
I have a list of dates for which projects are due to end, what I am trying to achieve is to highlight any date that is within a month of the project end date.
After searching around I think the E DATE function with TODAY are the functions to use,
I have ended up with the below formula which seems to work but I'm not sure if this is correct? If someone could please confirm if I'm on the right track that would be most appreciated
=IF(EDATE(H8,-1)<TODAY(),"Danger","ok")
Many Thanks
I have a list of dates for which projects are due to end, what I am trying to achieve is to highlight any date that is within a month of the project end date.
After searching around I think the E DATE function with TODAY are the functions to use,
I have ended up with the below formula which seems to work but I'm not sure if this is correct? If someone could please confirm if I'm on the right track that would be most appreciated
=IF(EDATE(H8,-1)<TODAY(),"Danger","ok")
Project End Date | Status |
Sep-23 | ok |
May-23 | Danger |
Jun-23 | ok |
Mar-24 | ok |
Jun-23 | ok |
Feb-24 | ok |
Mar-25 | ok |
Many Thanks