Forum Discussion
Excel how to calculate a date with different criteria
Can someone assist with another query please. I have start date and i want to add a deadline date for it looking at text as a driver for the date. As follows: A3 is the start date and in B3...
Hi,
I suggest using this formula:
=IF(ISNUMBER(SEARCH("major",C3)),A3+30,IF(ISNUMBER(SEARCH("delay",C3)),A3+25,""))
If you want the 30 or 25 days to be only working days (excluding the weekends), please check out this formula:
=IF(ISNUMBER(SEARCH("major",C3)),WORKDAY(A3,30),IF(ISNUMBER(SEARCH("delay",C3)),WORKDAY(A3,25),""))
Hope that helps