Share via

Excel formula help needed

Anonymous
2023-01-13T19:30:41+00:00

I'm having trouble finding the correct formula(s) and need some help please.

  • If Column C = ED then I need Column D to look at Column B and add 183 days (6 months). NOTE: I will also need to ensure whatever date appears in Column D will work with conditional formatting to change this date to red/yellow/green. The only formula that works for me to do this is the =Today() formula.

Thank you!! I appreciate your time and help with this formula.

Microsoft 365 and Office | Excel | For business | Windows

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

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. HansV 462.6K Reputation points
    2023-01-13T19:58:48+00:00

    In D3:

    =IF(C3="ED",EDATE(B3,6),"")

    Format D3 as a date, then fill down.

    With the range with formulas selected, D3 should be the active cell in the selection.

    On the Home tab of the ribbon, select Conditional Formatting > New Rule...

    Select 'Format only cells that contain'.

    Leave the first drop down set to 'Cell Value'.

    Select 'less than or equal to' from the second drop down.

    Enter =TODAY()+90 in the box next to it.

    Click Format...

    Activate the Fill tab.

    Select green.

    Click OK, then click OK again.

    Repeat these steps, but with =TODAY()+60 and yellow as color.

    Finally, repeat them with 'less than' and =TODAY() and red as color.

    Was this answer helpful?

    0 comments