DashboardNovice
Member
In the attached spreadsheet, a pay period ends on every other Friday (yellow). I am trying to come up with a formula that will determine the pay period ending date for any given date, i.e. for any date, round to the next highest pay period ending date.
I feel like I am somewhat close, but when I vary the 2nd argument in the WEEKDAY function, my results shift by 7. I also tried adding 14 to the current date instead of 7.
I am working on row 8.
I feel like I am somewhat close, but when I vary the 2nd argument in the WEEKDAY function, my results shift by 7. I also tried adding 14 to the current date instead of 7.
I am working on row 8.