Formula question

[Sportschamp]

I need a little help on a formula. I am trying to calculate leave time. So if your hire date is greater than 5yrs add 20hrs, if its greater then 10yrs add 60, and if greater than 20yrs add 98. Hopefully this makes sense. Any help would be great.

 

[abmati]

If Hire Date is in A1 cell, please apply following formula in B1 cell,
=IF(TODAY()>=EDATE(A1,20*12),98,IF(TODAY()>=EDATE(A1,10*12),60,IF(TODAY()>=EDATE(A1,5*12),20,0)))

Regards,

 

[Sportschamp]

Thanks Abmati
It worked perfect!

 

[Sportschamp]

Ok I have another formula I'm trying to figure out. Any help would be appreciated. I'm going to try my best to describe it. If in cell A1 through A10 are dollar amounts and in cell B1 through B10 are dates. I want a formula that will find the matching dates in the B column and then add the corresponding dollar amounts from the A column to get a total for each date. Hopefully this makes sense.

 

[Gilliam]

Ok I have another formula I'm trying to figure out. Any help would be appreciated. I'm going to try my best to describe it. If in cell A1 through A10 are dollar amounts and in cell B1 through B10 are dates. I want a formula that will find the matching dates in the B column and then add the corresponding dollar amounts from the A column to get a total for each date. Hopefully this makes sense.

see if this works for ya
=VLOOKUP((TODAY()-B1)/365,{0,0;5,20;10,60;20,98},2)+A1
Cheers

 

[konew1]

Ok I have another formula I'm trying to figure out. Any help would be appreciated. I'm going to try my best to describe it. If in cell A1 through A10 are dollar amounts and in cell B1 through B10 are dates. I want a formula that will find the matching dates in the B column and then add the corresponding dollar amounts from the A column to get a total for each date. Hopefully this makes sense.

If you want to add for one selected date then use =SUMIF(
With the date you want to sum for in B15 the =SUMIF(B1:B10,B15,A1:A10)

If you want a list giving the total for every date in B then use a pivot table