Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default how can i calculate the number of days passed between 2 dates ente

For days, you don't need DATEDIF.
=B1-A1 will do, if you format the result as Number or General.
DATEDIF makes sense if you are looking at months and/or years.
--
David Biddulph

Anthony wrote:
On Jan 3, 2:34 pm, jozef carpenter
wrote:
hi all, happy 2009! does someone know the option of calculating the
amount of days between 2 entered dates, so i can claculate the
average electricity use? many thnx in advance. jozef carpenter (so
not yet :-) an excel wizard)


This has worked for me in the past and can be used for number of days,
months, etc. between two dates:
=datedif(A1, B1, "d") where cells A1 and B1 contain the two dates.



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 I calculate the number of business days between two dates Anonymous New Users to Excel 3 June 18th 08 03:30 PM
calculate number of days btw dates Nelson Excel Worksheet Functions 2 March 2nd 06 01:02 AM
Formula to calculate number of days between Dates themax16 Excel Worksheet Functions 2 October 21st 05 01:38 PM
Calculate number of days in a column of dates Barbara Excel Discussion (Misc queries) 3 May 25th 05 04:21 PM
Calculate number of days in a column of dates Barbara Excel Discussion (Misc queries) 8 May 25th 05 02:48 PM


All times are GMT +1. The time now is 11:42 PM.

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"