| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Age calculator and Total number of year counting
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Age calculator and Total number of year counting
Hi,
Try this =DATEDIF(A1,TODAY(),"y") & " Years, " & DATEDIF(A1,TODAY(),"ym") & " Months " Calculates the difference between A1 and today. Mike "Arvind Saxena" wrote: 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Age calculator and Total number of year counting
Hi Mike,
Age calculator is working fine, Now I like to calculate total years of experience based on two dates -- --------------------- Arvind "Mike H" wrote: Hi, Try this =DATEDIF(A1,TODAY(),"y") & " Years, " & DATEDIF(A1,TODAY(),"ym") & " Months " Calculates the difference between A1 and today. Mike "Arvind Saxena" wrote: 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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Age calculator and Total number of year counting
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 "Arvind Saxena" wrote: 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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Age calculator and Total number of year counting
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 "Arvind Saxena" wrote: Hi Mike, Age calculator is working fine, Now I like to calculate total years of experience based on two dates -- --------------------- Arvind "Mike H" wrote: Hi, Try this =DATEDIF(A1,TODAY(),"y") & " Years, " & DATEDIF(A1,TODAY(),"ym") & " Months " Calculates the difference between A1 and today. Mike "Arvind Saxena" wrote: 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? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Age calculator and Total number of year counting
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 "Mike H" wrote: 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 "Arvind Saxena" wrote: Hi Mike, Age calculator is working fine, Now I like to calculate total years of experience based on two dates -- --------------------- Arvind "Mike H" wrote: Hi, Try this =DATEDIF(A1,TODAY(),"y") & " Years, " & DATEDIF(A1,TODAY(),"ym") & " Months " Calculates the difference between A1 and today. Mike "Arvind Saxena" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sub total data by year | Excel Worksheet Functions | |||
| Academic Year calculator | Excel Discussion (Misc queries) | |||
| Variance Total for less than complete year? | Excel Discussion (Misc queries) | |||
| Counting the total number of cells with specified condition(freque | Excel Discussion (Misc queries) | |||
Linear Mode
