Phil Smith
Active Member
- Joined
- Aug 13, 2004
- Messages
- 285
- Office Version
- 365
- Platform
- Mobile
Hi People of the Forum.
1) I wish to create a list of my paydays which occur every 4 weeks on a Friday. Easy enough. However...
2) I am scratching my head trying to come up with a workable formula to take into account whether a payday falls on a Bank Holiday, and if it does, have the payday fall one day early on the Thursday. However...
3) Should Payday Friday happen to fall on December 26th, it would firstly get moved to the 25th, which then means it would then have to be moved to Wednesday 24th December.
The column containing the list of paydays will start in A2. I also have a named range, "Bank_Holidays", which, surprisingly, contains the required bank holiday dates.?
Should a Excel wizard come up with a solution in VBA that is more than acceptable also.
Thanks in advance.
1) I wish to create a list of my paydays which occur every 4 weeks on a Friday. Easy enough. However...
2) I am scratching my head trying to come up with a workable formula to take into account whether a payday falls on a Bank Holiday, and if it does, have the payday fall one day early on the Thursday. However...
3) Should Payday Friday happen to fall on December 26th, it would firstly get moved to the 25th, which then means it would then have to be moved to Wednesday 24th December.
The column containing the list of paydays will start in A2. I also have a named range, "Bank_Holidays", which, surprisingly, contains the required bank holiday dates.?
Should a Excel wizard come up with a solution in VBA that is more than acceptable also.
Thanks in advance.