Share via

Need help with creating target dates

Anonymous
2023-04-13T11:02:33+00:00

Hi I need help!!! I am trying to create a formula to calculate a future date based on urgency, for instance if the urgency is " 2 day "I want it to place a date 2 days from referral date in a column, then if "Routine" a date 6 weeks from referral date and "asap" would be 2 weeks from referral date. Referral date is in column E and the urgency is in column I . The column i want the target date to enter is column M.

I've tried if and then function without success.

Any Tips

Microsoft 365 and Office | Excel | For business | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-04-17T08:45:50+00:00

    Have you tried it? Hope all goes well.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2023-04-13T13:14:20+00:00

    =IF(I2="2 day",E2+2,IF(I2="Routine",E2+42,IF(I2="asap",E2+14,"")))

    Was this answer helpful?

    0 comments
  3. HansV 462.6K Reputation points
    2023-04-13T12:12:03+00:00

    In M2:

    =IF(E2="", "", E2+IF(LOWER(I2)="routine", 42, IF(LOWER(I2)="asap", 14, IF(LOWER(I2)=" 2 day ", 2, 0))))

    (Is it really " 2 day "? Or should it be "2 day"? If the latter, modify the formula)

    Fill down.

    Was this answer helpful?

    0 comments