Forum Discussion

SPearson1973's avatar
SPearson1973
Copper Contributor
Jun 04, 2019

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 i want to put a due date - this needs to look at text in another column so it the column says Major overdue or Major Project it needs to have a deadline of 25 days from the start date and if the texts says Delay overdue or delay project i need the deadline date to be 25 days from the start date.  Hope this makes sense and thanks for any assistance

 

Sue

excel

2 Replies

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Jun 04, 2019

    SPearson1973

     

    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

Resources