skeeeter56
New Member
- Joined
- Nov 26, 2016
- Messages
- 42
- Office Version
- 2019
- Platform
- Windows
Hi just cant get this formula correct.
I need to check a date in a cell then work out the next workday, I have a list of holiday dates in a list.
=WORKDAY(EndDate,1,Holiday)
EndDate is the cell that contains the date and is a Range and is on a different sheet and Holiday is the list of the holiday dates.
I end up with #VALUE as the result.
I need to check a date in a cell then work out the next workday, I have a list of holiday dates in a list.
=WORKDAY(EndDate,1,Holiday)
EndDate is the cell that contains the date and is a Range and is on a different sheet and Holiday is the list of the holiday dates.
I end up with #VALUE as the result.