Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default "DATEDIFF" LOCATION IN EXCEL 2007

i AM ATTEMPTING TO DO AN ELAPSED TIME CALCULATION USING THE "DATEDIFF"
FUNCTION SUGGESTED IN SEVERAL POSTINGS ON THE DISCUSSION GROUP. WHERE DO I
FIND IT?
--
Grateful
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,651
Default "DATEDIFF" LOCATION IN EXCEL 2007

One F, not 2, if you are looking for the Excel function.
But don't look for it in Excel help or the function wizard, as it hasn't
been there since Excel 2000.
If you need info, look at http://www.cpearson.com/excel/datedif.aspx

If you really do want datediff with 2 Fs, that's in VBA.

And please don't SHOUT.
--
David Biddulph

"dickvw" wrote in message
...
i AM ATTEMPTING TO DO AN ELAPSED TIME CALCULATION USING THE "DATEDIFF"
FUNCTION SUGGESTED IN SEVERAL POSTINGS ON THE DISCUSSION GROUP. WHERE DO
I
FIND IT?
--
Grateful



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
How can you "save as" in excel 2007 (and word 2007)? gofordan Excel Discussion (Misc queries) 2 September 6th 07 09:52 PM
change "true" and "false" to "availble" and "out of stock" inthestands Excel Worksheet Functions 2 July 19th 07 07:05 PM
Typing "true" excel 2007 change it to "TRUE" Mr. T Excel Discussion (Misc queries) 2 April 11th 07 01:24 PM
HELP on "left","right","find","len","substitute" functions serene83 Excel Discussion (Misc queries) 5 June 27th 06 02:23 AM
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next BCB New Users to Excel 7 May 13th 06 10:02 PM


All times are GMT +1. The time now is 07:44 AM.

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

About Us

"It's about Microsoft Excel"