Calculate a deadline

Copper Contributor

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!

 

1 Reply

@emilycharlton 

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,"???")