I want to calculate number of years, months and days between a hire date and
today's date.
I want to calculate number of years, months and days between a hire date and
today's date.
Try this with the hire date in C4
=DATEDIF(C4,TODAY(),"y") & " y " & DATEDIF(C4,TODAY(),"ym") & " m " & DATEDIF(C4,TODAY(),"md") & " d"
--
Regards Ron de Bruin
http://www.rondebruin.nl
"ruby" <[email protected]> wrote in message news:[email protected]...
>I want to calculate number of years, months and days between a hire date and
> today's date.
Look at the advice offered at this link
http://www.cpearson.com/excel/datedif.htm
"ruby" wrote:
> I want to calculate number of years, months and days between a hire date and
> today's date.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks