Formula Assistance

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mharper - 11 Jul 2007 19:38 GMT

I have a formula to calculate amount of days from a hire date to current
date, but I would like to see the days to reflect amount of years and months

any assistance would be appreciated thanks!

Reply to this Message

Bob Phillips - 11 Jul 2007 19:53 GMT

=DATEDIF(A1,TODAY(),"Y")&" years, "&DATEDIF(A1,TODAY(),"YM")&" months"

Signature

---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

>I have a formula to calculate amount of days from a hire date to current
> date, but I would like to see the days to reflect amount of years and
> months
>
> any assistance would be appreciated thanks!

Reply to this Message

Mharper - 11 Jul 2007 20:10 GMT

that worked thank you so much!

> I have a formula to calculate amount of days from a hire date to current
> date, but I would like to see the days to reflect amount of years and months
>
> any assistance would be appreciated thanks!

Reply to this Message