Age calculator and Total number of year counting

[Guest]

Hi,

I would like to have one Excel sheet in my Resume -- which will calculate my
age as of today and it will count total expersinace in the format of year
month.

Example:
[1] If enter DOB -- 15/6/1980(DD/MM/YYYY) -- answer will be 27 year 6 month

[2] Resume

company 1 -- worked from SEP 05 to OCT 06
company 2 -- worked from NOV 06 to Dec 07

total expr is 2 year 6 month

can somebody help on this?

 

[Guest]

Hi,

Try this

=DATEDIF(A1,TODAY(),"y") & " Years, " & DATEDIF(A1,TODAY(),"ym") & " Months "

Calculates the difference between A1 and today.

Mike

 

[Guest]

Hi Mike,

Age calculator is working fine, Now I like to calculate total years of
experience based on two dates
--
---------------------
Arvind

Hi,

Try this

=DATEDIF(A1,TODAY(),"y") & " Years, " & DATEDIF(A1,TODAY(),"ym") & " Months "

Calculates the difference between A1 and today.

Mike

Hi,

I would like to have one Excel sheet in my Resume -- which will calculate my
age as of today and it will count total expersinace in the format of year
month.

Example:
[1] If enter DOB -- 15/6/1980(DD/MM/YYYY) -- answer will be 27 year 6 month

[2] Resume

company 1 -- worked from SEP 05 to OCT 06
company 2 -- worked from NOV 06 to Dec 07

total expr is 2 year 6 month

can somebody help on this?

 

[Guest]

Chip Pearson has a lot of info on calculating dates, time lapsed between
dates and such beginning here (be sure to read on down the page)
http://cpearson.com/excel/datedif.htm#Age

 

[Guest]

Hi,

You use the same formula

=DATEDIF(A1,A2,"y") & " Years, " & DATEDIF(A1,A2,"ym") & "

but replace A1 - A2 with the start and end dates of that employment. A1 must
be the earlier date.

Mike

Hi Mike,

Age calculator is working fine, Now I like to calculate total years of
experience based on two dates
--
---------------------
Arvind

Hi,

Try this

=DATEDIF(A1,TODAY(),"y") & " Years, " & DATEDIF(A1,TODAY(),"ym") & " Months "

Calculates the difference between A1 and today.

Mike

Hi,

I would like to have one Excel sheet in my Resume -- which will calculate my
age as of today and it will count total expersinace in the format of year
month.

Example:
[1] If enter DOB -- 15/6/1980(DD/MM/YYYY) -- answer will be 27 year 6 month

[2] Resume

company 1 -- worked from SEP 05 to OCT 06
company 2 -- worked from NOV 06 to Dec 07

total expr is 2 year 6 month

can somebody help on this?

 

[Guest]

Hey Mike,

How DO I do total of all --

Example:

company 1 --sep-00 to sep02 -- 2 year
Company 2 --Oct-02 to Oct 04 -- 2 year

Total exper is 4 year
--
---------------------
Arvind

Hi,

You use the same formula

=DATEDIF(A1,A2,"y") & " Years, " & DATEDIF(A1,A2,"ym") & "

but replace A1 - A2 with the start and end dates of that employment. A1 must
be the earlier date.

Mike

Hi Mike,

Age calculator is working fine, Now I like to calculate total years of
experience based on two dates
--
---------------------
Arvind

Hi,

Try this

=DATEDIF(A1,TODAY(),"y") & " Years, " & DATEDIF(A1,TODAY(),"ym") & " Months "

Calculates the difference between A1 and today.

Mike

:

Hi,

I would like to have one Excel sheet in my Resume -- which will calculate my
age as of today and it will count total expersinace in the format of year
month.

Example:
[1] If enter DOB -- 15/6/1980(DD/MM/YYYY) -- answer will be 27 year 6 month

[2] Resume

company 1 -- worked from SEP 05 to OCT 06
company 2 -- worked from NOV 06 to Dec 07

total expr is 2 year 6 month

can somebody help on this?