| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to count no. of months between 2 dates
What is the formula to display the number of months between 2 dates?
Thanks, Melissa |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula to count no. of months between 2 dates
Have a look at this site:
http://www.cpearson.com/excel/datedif.aspx -- Regards! Stefi €˛Melissa€¯ ezt Ć*rta: What is the formula to display the number of months between 2 dates? Thanks, Melissa |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula to count no. of months between 2 dates
I forgot to mention I am using Excel 2000.
I used this formula: dateif(A3,A2,"m") and got a #NAME? result. My dates are all in column A (in ascending order). "Stefi" wrote: Have a look at this site: http://www.cpearson.com/excel/datedif.aspx -- Regards! Stefi €˛Melissa€¯ ezt Ć*rta: What is the formula to display the number of months between 2 dates? Thanks, Melissa |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula to count no. of months between 2 dates
There is no function DATEIF, so that is why you got the #NAME? result.
Try DATEDIF. -- David Biddulph "Melissa" wrote in message ... I forgot to mention I am using Excel 2000. I used this formula: dateif(A3,A2,"m") and got a #NAME? result. My dates are all in column A (in ascending order). "Stefi" wrote: Have a look at this site: http://www.cpearson.com/excel/datedif.aspx -- Regards! Stefi "Melissa" ezt ķrta: What is the formula to display the number of months between 2 dates? Thanks, Melissa |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula to count no. of months between 2 dates
Thanks!
"David Biddulph" wrote: There is no function DATEIF, so that is why you got the #NAME? result. Try DATEDIF. -- David Biddulph "Melissa" wrote in message ... I forgot to mention I am using Excel 2000. I used this formula: dateif(A3,A2,"m") and got a #NAME? result. My dates are all in column A (in ascending order). "Stefi" wrote: Have a look at this site: http://www.cpearson.com/excel/datedif.aspx -- Regards! Stefi "Melissa" ezt Ć*rta: What is the formula to display the number of months between 2 dates? Thanks, Melissa . |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula to count no. of months between 2 dates
=DATEDIF(A1,B1,"m")
On 23 Mar, 08:27, Melissa wrote: What is the formula to display the number of months between 2 dates? Thanks, Melissa |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count the number of months between two dates | Excel Worksheet Functions | |||
| formula to caluclate the # of years and months between two dates | Excel Worksheet Functions | |||
| formula to caluclate the # of years and months between two dates | Excel Worksheet Functions | |||
| formula to caluclate the # of years and months between two dates | Excel Worksheet Functions | |||
| formula to caluclate the # of years and months between two dates | Excel Worksheet Functions | |||
Hybrid Mode
