Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Kaddy
 
Posts: n/a
Default Does Excel 2000 have a 'datedif' function to calculate the number.

I want to calculate the number of months between a fixed date and todays
date.
I don't see where Excel 2000 has a 'datedif' function. Does Excel 2003 have
this function?
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
it has (though n ot mentioned in the help file). See:
http://www.cpearson.com/excel/datedif.htm

--
Regards
Frank Kabel
Frankfurt, Germany

Kaddy wrote:
I want to calculate the number of months between a fixed date and
todays date.
I don't see where Excel 2000 has a 'datedif' function. Does Excel
2003 have this function?



  #3   Report Post  
Ron Rosenfeld
 
Posts: n/a
Default

On Fri, 10 Dec 2004 15:17:02 -0800, "Kaddy"
wrote:

I want to calculate the number of months between a fixed date and todays
date.
I don't see where Excel 2000 has a 'datedif' function. Does Excel 2003 have
this function?


Excel 2000 does have this function, although it may not be documented in HELP.

=DATEDIF(StartDate, EndDate, "m")

See http://www.cpearson.com/excel/datedif.htm for documentation.




--ron
  #4   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

I believe 2000 is the only version where it is documented

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"Ron Rosenfeld" wrote in message
...
On Fri, 10 Dec 2004 15:17:02 -0800, "Kaddy"

wrote:

I want to calculate the number of months between a fixed date and todays
date.
I don't see where Excel 2000 has a 'datedif' function. Does Excel 2003
have
this function?


Excel 2000 does have this function, although it may not be documented in
HELP.

=DATEDIF(StartDate, EndDate, "m")

See http://www.cpearson.com/excel/datedif.htm for documentation.




--ron



  #5   Report Post  
Gord Dibben
 
Posts: n/a
Default

Ron

AFAIK Excel 2000 was the ONLY version to document the DATEDIF Function in
Help.

Gord Dibben Excel MVP

On Fri, 10 Dec 2004 20:46:02 -0500, Ron Rosenfeld
wrote:

On Fri, 10 Dec 2004 15:17:02 -0800, "Kaddy"
wrote:

I want to calculate the number of months between a fixed date and todays
date.
I don't see where Excel 2000 has a 'datedif' function. Does Excel 2003 have
this function?


Excel 2000 does have this function, although it may not be documented in HELP.

=DATEDIF(StartDate, EndDate, "m")

See http://www.cpearson.com/excel/datedif.htm for documentation.




--ron




  #6   Report Post  
Ron Rosenfeld
 
Posts: n/a
Default

On Fri, 10 Dec 2004 18:03:47 -0800, Gord Dibben <gorddibbATshawDOTca wrote:

Ron

AFAIK Excel 2000 was the ONLY version to document the DATEDIF Function in
Help.

Gord Dibben Excel MVP

On Fri, 10 Dec 2004 20:46:02 -0500, Ron Rosenfeld
wrote:

On Fri, 10 Dec 2004 15:17:02 -0800, "Kaddy"
wrote:

I want to calculate the number of months between a fixed date and todays
date.
I don't see where Excel 2000 has a 'datedif' function. Does Excel 2003 have
this function?


Excel 2000 does have this function, although it may not be documented in HELP.

=DATEDIF(StartDate, EndDate, "m")

See http://www.cpearson.com/excel/datedif.htm for documentation.




--ron


Well, that's why I said "may not be documented" and did not say "is not
documented".

I knew there was one that had it, and I thought it was 2000. But when the OP
wondered if it was in 2000, I thought well maybe 2000 that doesn't have it
documented.

I've never run 2000, although I've used versions before and after.


--ron
  #7   Report Post  
Gord Dibben
 
Posts: n/a
Default

Ron

Not a criticism of your post.

Just info only for all readers, especially the OP who could not find a
reference to DATEDIF in 2000 Help.

Your "may not be documented" was noted by myself.

Gord

On Fri, 10 Dec 2004 21:42:13 -0500, Ron Rosenfeld
wrote:

Well, that's why I said "may not be documented" and did not say "is not
documented".

I knew there was one that had it, and I thought it was 2000. But when the OP
wondered if it was in 2000, I thought well maybe 2000 that doesn't have it
documented.

I've never run 2000, although I've used versions before and after.


  #8   Report Post  
Ron Rosenfeld
 
Posts: n/a
Default

On Sat, 11 Dec 2004 10:05:12 -0800, Gord Dibben <gorddibbATshawDOTca wrote:

Ron

Not a criticism of your post.

Just info only for all readers, especially the OP who could not find a
reference to DATEDIF in 2000 Help.

Your "may not be documented" was noted by myself.

Gord


No offense was taken. Just conversation. Sometimes tough to read nuances in
this medium, though.


--ron
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Excel 2002 and 2000 co-install. Control Which Starts ? cnuk Excel Discussion (Misc queries) 2 January 17th 05 09:07 PM
How do you calculate the nth root of a number in Excel 2003? William Excel Worksheet Functions 2 November 17th 04 05:19 PM
IF/ LOOKUP FUNCTION - Excel 2000 Chandrashekhar Excel Worksheet Functions 3 November 5th 04 12:02 PM
Statistical Excel Function Question within Excel 2000... Drew H Excel Worksheet Functions 3 October 31st 04 07:55 PM


All times are GMT +1. The time now is 10:19 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"