ExcelFanatic
Board Regular
- Joined
- May 22, 2009
- Messages
- 83
I have a worksheet showing events and have created a statement to show whether the event is complete, ongoing, next, or planned.
=IF($C2="Ongoing","Next",IF($B3<today(),"complete",IF(and($a3<today(),$b3>TODAY()),"Ongoing","Planned")))
The formula works great if there is an event that is ongoing, however if there are not ongoing events, it shows all future events as "Planned".
If there is not a ongoing event, I want to show the next event after a completed event as "Next", and all events after as "Planned" .
A - Start Date
B - End Date
C - Status
Thanks
=IF($C2="Ongoing","Next",IF($B3<today(),"complete",IF(and($a3<today(),$b3>TODAY()),"Ongoing","Planned")))
The formula works great if there is an event that is ongoing, however if there are not ongoing events, it shows all future events as "Planned".
If there is not a ongoing event, I want to show the next event after a completed event as "Next", and all events after as "Planned" .
A - Start Date
B - End Date
C - Status
Thanks