brianfosterblack
Active Member
- Joined
- Nov 1, 2011
- Messages
- 251
I am trying to get a formula for the first payday of the year depending on a clients requirement. I have this formula to get the first Monday
However some of my clients choose their own day of the week to do payslips and I enter the day of the week in cell D63 (It could be any day from Monday through to Friday)
Some I do the payslip every Second week in which case I would have to find that second day in the year. Can anyone help with a formula which actually uses the Weekday entered in D63 and in B63 I enter the frequency (Weekly or BIWeekly)
Excel Formula:
=(DATE(D2,1,1)+CHOOSE(WEEKDAY(DATE(D2,1,1),2),0,6,5,4,3,2,1))
Some I do the payslip every Second week in which case I would have to find that second day in the year. Can anyone help with a formula which actually uses the Weekday entered in D63 and in B63 I enter the frequency (Weekly or BIWeekly)