Payroll Date/Anniversary Calculations?!?
I need to input a Date of Hire then I need excel to calculate (Regardless of the date) the nearest/first Bi-weekly payday. Then, excel needs to calculate in the rest of the cells/columns the 6 month anniversary date Which should land on a Payday Friday, then 1 year anniversary date etc.etc....
I Am having a heck of a time?
Post a sample workbook showing a)what you want to start with, b) how you want it to look and ideally c) explain how you get from one to the other.
Click * below if this answer helped
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks