Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting Months
Cell A1 is a date and cell A2 is a date. what formula can I use to make A3 return the correct amount of months between these two dates. Example: A1 = 6/1/2006 A2 = 9/01/2007 A3 = 15 PS - A1 and A2 are formatted as DATES -- jermsalerms ------------------------------------------------------------------------ jermsalerms's Profile: http://www.excelforum.com/member.php...o&userid=30167 View this thread: http://www.excelforum.com/showthread...hreadid=548738 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting Months
one way
=(A2-A1)/30.42 format as number --no decimals. -- Greetings from New Zealand Bill K "jermsalerms" wrote in message ... Cell A1 is a date and cell A2 is a date. what formula can I use to make A3 return the correct amount of months between these two dates. Example: A1 = 6/1/2006 A2 = 9/01/2007 A3 = 15 PS - A1 and A2 are formatted as DATES -- jermsalerms ------------------------------------------------------------------------ jermsalerms's Profile: http://www.excelforum.com/member.php...o&userid=30167 View this thread: http://www.excelforum.com/showthread...hreadid=548738 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting Months
=(YEAR(A2)-YEAR(A1))*12+MONTH(A2)-MONTH(A1)
Format as standard |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting Months
"jermsalerms"
wrote in message ... Cell A1 is a date and cell A2 is a date. what formula can I use to make A3 return the correct amount of months between these two dates. Example: A1 = 6/1/2006 A2 = 9/01/2007 A3 = 15 PS - A1 and A2 are formatted as DATES =DATEDIF(A1,A2,"m") http://www.cpearson.com/excel/datedif.htm -- David Biddulph |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
counting dates in a column that less than 6 months from today | Excel Discussion (Misc queries) | |||
Counting dates for a the present month but not future months | Excel Worksheet Functions | |||
Counting Months | Excel Worksheet Functions | |||
Counting months | Excel Worksheet Functions | |||
Why "datedif" function results sometimes negative numbers? | Excel Worksheet Functions |