Paid time of accrual rate formula

steve89

Board Regular
Joined
Oct 4, 2015
Messages
152
hi everyone im looking to have an accrual formula developed ive tried for a while works but not quite. This is the breakdown:

i have a sheet that is universally used by many account and they just change they year and everything else follows. Recently i want to develop an accrual calculator for account managers. So they need to reference the following:

=YTD1J4 (which is the year that the manager enters)
hire date is C4 which is spelled out like so 4/12/12
what is there CURRENT accrued paid time off. not based on the years they worked but the current year hence using YTD!J4. Now i want to use cell C104 as a place where the max accrued rate would be and in this case if you work more then 2 years would be 80 hours or two weeks and less then two years would be 40 hours or 5 days. They have to accrue this monthly and not just get a automatic 2 week paid time off but rather it accrues. Here the thing the formula also has to incorporate and "if" or "or" formula as it has to say if D4="Full time")*C104 (which is the facilities max earned time off)

any help would be appreciate thank you all so much.
 

Some videos you may like

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

Watch MrExcel Video

Forum statistics

Threads
1,123,312
Messages
5,600,887
Members
414,414
Latest member
neil_c

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top