LaurenHancy
Board Regular
- Joined
- Aug 5, 2010
- Messages
- 179
Hi All,
I have a drop down with a specific month, my forula does the trick and displays all dates for that month, but how can I display WORKDAY's only? I am a bit stuck, your help is appreciated.
A1 = Dropdown date:
=IF(A1="","",DATEVALUE("1 "&A1))
The in next cell this formula:
=IF(F6="","",IF(MONTH(F6)<>MONTH(F6+1),"",F6+1))
Thank you
I have a drop down with a specific month, my forula does the trick and displays all dates for that month, but how can I display WORKDAY's only? I am a bit stuck, your help is appreciated.
A1 = Dropdown date:
=IF(A1="","",DATEVALUE("1 "&A1))
The in next cell this formula:
=IF(F6="","",IF(MONTH(F6)<>MONTH(F6+1),"",F6+1))
Thank you