Status update formula

J

jimburgg

I want a formula that will update the status of where a project is by finding
where the =today() is on the spreadsheet. Below is what I have so far, but it
will not indicate more that one status (if it were at Saftey and PLE as an
example), it will only indicate the first match. I would also like it to
indicate N/A or No Satus if there is no =today() formula used for a quick
visual indication of where things are. Any suggections?

=IF(Q339=(TODAY()),"Safety",IF(S339=(TODAY()),"TOMA",IF(V339=(TODAY()),"PLE",IF(AB339=(TODAY()),"IPT",IF(AF339=(TODAY()),"TOMA",IF(AI339=(TODAY()),"TW",IF(AL339=(TODAY()),"TOMA",IF(AO339=(TODAY()),"PPR
IPT",IF(AQ339=(TODAY()),"TOMA",IF(AS339=(TODAY()),"D/C",IF(AW339=(TODAY()),"P/D",)))))))))))
 
Top