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.
Please suggest.
Thanks
Bookmarks