Oldham_mark
New Member
- Joined
- Jan 28, 2015
- Messages
- 2
Hi
I am trying to find a formula that will bring up the previous working day if the day I input is not a working day (due to either a weekend or Bank Holiday). If the day input is a working day I would like to bring back that day.
If I input a date in cell A1, and wish to return the corrected date in cell B1, what formula would I need in B1?
I have been using =WEEKDAY(A1+1,-1) but this only corrects the date for weekends, not Bank Holidays
Many Thanks
I am trying to find a formula that will bring up the previous working day if the day I input is not a working day (due to either a weekend or Bank Holiday). If the day input is a working day I would like to bring back that day.
If I input a date in cell A1, and wish to return the corrected date in cell B1, what formula would I need in B1?
I have been using =WEEKDAY(A1+1,-1) but this only corrects the date for weekends, not Bank Holidays
Many Thanks