I have a spreadsheet that has paycheck dates in it(Column G). We start processing the payroll a week before that. If that day is a non-business day we begin on the previous business day. For example if the paycheck date is 10/12(a Friday) a week before that be 10/05(a Friday). That is good.
If the paycheck date is 10/14(a Sat) then the start date would be 10/05(a Friday) instead of exactly a week before; which would be Saturday. The start date is in Column E.
I was playing with IF statements, but can't quite get it. I'm not even sure if that is the easiest way to do it.
Can anyone recommend a way to do this?
Thanks,
Craig
Bookmarks