S
sonar
Problem solved by using the following coding
Cell A: =(DATEDIF(D9,NOW(),"y")*12+DATEDIF(D9,NOW(),"ym"))
Cell B: Cell A * (cell with the formula of 30 days per year / 12 month
to give 2.5 days per month)
This gives me:
converts years "y" into months by multiplying it by 12, and adding th
month "ym" already calculated.
Then I multiply the 2.5 by the total of months to give me amount o
days accrued.
Regars
Sona
Cell A: =(DATEDIF(D9,NOW(),"y")*12+DATEDIF(D9,NOW(),"ym"))
Cell B: Cell A * (cell with the formula of 30 days per year / 12 month
to give 2.5 days per month)
This gives me:
converts years "y" into months by multiplying it by 12, and adding th
month "ym" already calculated.
Then I multiply the 2.5 by the total of months to give me amount o
days accrued.
Regars
Sona