| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Total number of months.
Hi Experts,
What i want to do is calculate the number of months between 2 dates. For example: Date of joining - 01-Aug-2004 Today's Date - 21-Dec-2006 1. What would be the formula for calculating the number of months. 2. What would be the formula for calculating the number of years. 3. What would be the formula for calculating the number of days. thanks in advance for any help. Gary |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Total number of months.
Hi Gary,
Look he http://www.cpearson.com/excel/datedif.htm -- Kind regards, Niek Otten Microsoft MVP - Excel "Gary" wrote in message ... | Hi Experts, | | What i want to do is calculate the number of months between 2 dates. | | For example: | | Date of joining - 01-Aug-2004 | Today's Date - 21-Dec-2006 | | 1. What would be the formula for calculating the number of months. | | 2. What would be the formula for calculating the number of years. | | 3. What would be the formula for calculating the number of days. | | thanks in advance for any help. | | Gary | | |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Total number of months.
Hi Gary
1.=DATEDIF(DateOfJoining,TODAY(),"m") 2.=DATEDIF(DateOfJoining,TODAY(),"y") 3.=DATEDIF(DateOfJoining,TODAY(),"d") Replace DateOfJoining with whatever cell ref holds your date (ie 1/Aug/2004). The last one is very simple as it is really only =TODAY()-"01Aug2004". This will give you the number of days between the two dates. Hope this helps! Richard Gary wrote: Hi Experts, What i want to do is calculate the number of months between 2 dates. For example: Date of joining - 01-Aug-2004 Today's Date - 21-Dec-2006 1. What would be the formula for calculating the number of months. 2. What would be the formula for calculating the number of years. 3. What would be the formula for calculating the number of days. thanks in advance for any help. Gary |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Total number of months.
Great.....Thanks a ton :)
"RichardSchollar" wrote in message s.com... Hi Gary 1.=DATEDIF(DateOfJoining,TODAY(),"m") 2.=DATEDIF(DateOfJoining,TODAY(),"y") 3.=DATEDIF(DateOfJoining,TODAY(),"d") Replace DateOfJoining with whatever cell ref holds your date (ie 1/Aug/2004). The last one is very simple as it is really only =TODAY()-"01Aug2004". This will give you the number of days between the two dates. Hope this helps! Richard Gary wrote: Hi Experts, What i want to do is calculate the number of months between 2 dates. For example: Date of joining - 01-Aug-2004 Today's Date - 21-Dec-2006 1. What would be the formula for calculating the number of months. 2. What would be the formula for calculating the number of years. 3. What would be the formula for calculating the number of days. thanks in advance for any help. Gary |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Total number of months.
Thanks Niek :)
"Niek Otten" wrote in message ... Hi Gary, Look he http://www.cpearson.com/excel/datedif.htm -- Kind regards, Niek Otten Microsoft MVP - Excel "Gary" wrote in message ... | Hi Experts, | | What i want to do is calculate the number of months between 2 dates. | | For example: | | Date of joining - 01-Aug-2004 | Today's Date - 21-Dec-2006 | | 1. What would be the formula for calculating the number of months. | | 2. What would be the formula for calculating the number of years. | | 3. What would be the formula for calculating the number of days. | | thanks in advance for any help. | | Gary | | |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula to count number of months that have passed | Excel Discussion (Misc queries) | |||
| Can I total only a % of a number (cell) base on total of all cel | Excel Discussion (Misc queries) | |||
| Add total number of rows (text) in a column | Excel Worksheet Functions | |||
| Need to Count number of occurrences and get percentage of total | Excel Worksheet Functions | |||
| how to calculate total months from month/year | Excel Discussion (Misc queries) | |||
Linear Mode
