Stclements1
Board Regular
- Joined
- Sep 15, 2018
- Messages
- 150
- Office Version
- 365
- Platform
- Windows
I have this formula which I am grateful for the help from MrExcel users guidance, but having used it,the problem I have is that it can give me the start and end date of the same month as I asked for it to give me the last Workday at the end of the month but in reflection what I actually want it to do is give me the first Workday of each month. I have added a +before the final numeric 1 but that changed nothing.
=IF(ROWS(E$2:E2)>($B$4*12);"";WORKDAY(EOMONTH(B$2;D2-1)-1;1))
=IF(ROWS(E$2:E2)>($B$4*12);"";WORKDAY(EOMONTH(B$2;D2-1)-1;1))