Hello,
I'm new to Excel, so please bear with me.
I want to calculate the accrual of vacation time, which accrues every 14 days at a rate of 4 hours per pay period (the pay period is every 14 days). I have two columns of data; column A contains pay period 1 thru 26, and col B contains the pay period ending date (26 of those, 01/06/02 thru 12/22/02). I want to determine the current pay period based on the date, and post that pay period number (such as pay period 6)to a specific cell. Can anyone tell me how to go about this?...Hope this was not too confusing.
I'm new to Excel, so please bear with me.
I want to calculate the accrual of vacation time, which accrues every 14 days at a rate of 4 hours per pay period (the pay period is every 14 days). I have two columns of data; column A contains pay period 1 thru 26, and col B contains the pay period ending date (26 of those, 01/06/02 thru 12/22/02). I want to determine the current pay period based on the date, and post that pay period number (such as pay period 6)to a specific cell. Can anyone tell me how to go about this?...Hope this was not too confusing.