Nov 27 2021 05:54 AM
Hi, I was wondering if anyone could help me with an issue I'm having. I would like excel to automatically calculate a deadline for me based on information in another cell.
I would like column D to calculate the deadline based on the time frame given to complete the action in Row C (or even better to know automatically what the time frame is from the information in column B and calculate it that way)?
Thanks!
Nov 27 2021 07:04 AM
In D2:
=IFS(UPPER(RIGHT(C2,4))="DAYS",A2+LEFT(C2,LEN(C2)-5),UPPER(RIGHT(C2,5))="HOURS",A2+LEFT(C2,LEN(C2)-6)/24,TRUE,"???")