| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
counting the number or months between two dates.
How do I count the number of months between two dates.
-- Lisa M. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
counting the number or months between two dates.
=DATEDIF(A1,A2,"ym")
-- ** John C ** Please remember if your question is answered, to mark it answered :). It helps everyone. "Lisa" wrote: How do I count the number of months between two dates. -- Lisa M. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
counting the number or months between two dates.
Ok Maybe I did something wrong.
I used =DATEDIF(A1,A2,"ym") with A1 as 4/30/2007 and A2 as 11/30/2008 result was 7 ???????? -- Lisa M. "John C" wrote: =DATEDIF(A1,A2,"ym") -- ** John C ** Please remember if your question is answered, to mark it answered :). It helps everyone. "Lisa" wrote: How do I count the number of months between two dates. -- Lisa M. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
counting the number or months between two dates.
If you want months only,use "m" instead of "ym"
"ym" is used when you strip off the year y = year ym = months after year(s) is removed m = months md = days after months have been stripped off d = days but you might was well use end-start on that one -- Regards, Peo Sjoblom "Lisa" wrote in message ... Ok Maybe I did something wrong. I used =DATEDIF(A1,A2,"ym") with A1 as 4/30/2007 and A2 as 11/30/2008 result was 7 ???????? -- Lisa M. "John C" wrote: =DATEDIF(A1,A2,"ym") -- ** John C ** Please remember if your question is answered, to mark it answered :). It helps everyone. "Lisa" wrote: How do I count the number of months between two dates. -- Lisa M. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
counting the number or months between two dates.
On Thu, 6 Nov 2008 13:30:06 -0800, Lisa wrote:
Ok Maybe I did something wrong. I used =DATEDIF(A1,A2,"ym") with A1 as 4/30/2007 and A2 as 11/30/2008 result was 7 Try: =DATEDIF(A1,A2,"m") --ron |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
counting the number or months between two dates.
my bad, sorry, I am so used to typing "ym" that i was on autopilot. See the
other 2 posts for corrections :) -- ** John C ** "Lisa" wrote: Ok Maybe I did something wrong. I used =DATEDIF(A1,A2,"ym") with A1 as 4/30/2007 and A2 as 11/30/2008 result was 7 ???????? -- Lisa M. "John C" wrote: =DATEDIF(A1,A2,"ym") -- ** John C ** Please remember if your question is answered, to mark it answered :). It helps everyone. "Lisa" wrote: How do I count the number of months between two dates. -- Lisa M. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting Number of Months in the Top 33% | Excel Discussion (Misc queries) | |||
| Counting Specific Number of Days across Multiple Months | Links and Linking in Excel | |||
| 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 | |||
| Number of months between 2 dates | New Users to Excel | |||
![Lisa[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
