Hello,
I was hoping to find a formula that would help me get a an update on the status of a project based on two dates.
Very simply put, I wish there was a formula out there that would look at both dates and return a value based on today's date:
- Completed
- Ongoing
- Upcoming
I have the start date in B and end date in C and would like the coveted formula in A.
I attached a screenshot to (hopefully) make it clearer. I've tested out IF and AND formulas but have hit a wall.
Any help would be much appreciated - even if it's to tell me I'm chasing something that doesn't exist
Thanks in advance!
Bookmarks