# Calculate Working days based on drop down

1. ## Calculate Working days based on drop down

Hello,

I have a requirement into Excel, which will calculate working days for drop down 1 and 2.

And for 3rd drop down, calculation will be 2 weeks days (including weekends).

For e.g. - I have below drop down list :

Project 1
Project 2
Project 3

And 2 columns as Date Received and Date Closed

If the user selects, Project 1 or Project 2, and against this if the working days are more than 2, cell to get highlight.

If the user selects Project 3, calculation will be 2 weeks. And if it is more than 2 weeks, cell to get highlight.

Any other ideas are still welcome.

Thanks

2. ## Re: Calculate Working days based on drop down

There are instructions at the top of the page explaining how to attach your sample workbook.

3. ## Re: Calculate Working days based on drop down

I've attached a sample workbook.

In row 4, user has selected Project 2 and we get the result as 3 working days. Hence the cell has been highlighted. If for the same row, the option is selected as Project 3, the cell should not get highlighted.

Now if we see row 5, option is selected as Project 3, the result is showing more than 2 working days, but yet the cell should not get highlight.

For Project 1 and Project 2, if more than 2 working days, cells to get highlighted.

If Project 3 selected, and it is more than 2 weeks cells to get highlighted.

4. ## Re: Calculate Working days based on drop down

Try this CF rule:

=OR(AND(\$D2="Project 3",\$E2>14),AND(\$D2<>"Project 3",\$E2>2))

5. ## Re: Calculate Working days based on drop down

Thanks ! this did the trick