pennynikkel
New Member
- Joined
- Sep 3, 2003
- Messages
- 41
I'm trying to create formulas to set paydays into a spreadsheet. For example
1) First pay day is 10 calendar days after the previous month's end. i.e. Feb 16 - 29 would be pay day March 10, but consider that if the 10th day falls on a Saturday, Sunday or Holiday, then it has to be the next soonest working day. ie. June 16 - 30 would be pay day July 9th.
2) 2nd pay day is 10 calendar days after the 15th of the month, with same guidelines as above, in that if the 10th day is a holiday or weekend, then the payday falls on the nearest workday. i.e. September 16 - 30th pay day is October 8th.
Thank you very much.
1) First pay day is 10 calendar days after the previous month's end. i.e. Feb 16 - 29 would be pay day March 10, but consider that if the 10th day falls on a Saturday, Sunday or Holiday, then it has to be the next soonest working day. ie. June 16 - 30 would be pay day July 9th.
2) 2nd pay day is 10 calendar days after the 15th of the month, with same guidelines as above, in that if the 10th day is a holiday or weekend, then the payday falls on the nearest workday. i.e. September 16 - 30th pay day is October 8th.
Thank you very much.