#1   Report Post  
tooks
 
Posts: n/a
Default formulae

I require a formula that will count how many days between two dates.eg
23/05/02 and23/05/03. Using the rcommended formula days360(the two
dates here)gives the answer 1 as in one year.........help meeeee please!
  #2   Report Post  
Ragdyer
 
Posts: n/a
Default

You want the DateDif() function.

It's undocumented, except in XL2k, so Chip Pearson has fully explained it in
his web site:

http://www.cpearson.com/excel/datedif.htm
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"tooks" wrote in message
...
I require a formula that will count how many days between two dates.eg
23/05/02 and23/05/03. Using the rcommended formula days360(the two
dates here)gives the answer 1 as in one year.........help meeeee please!


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

On Sun, 15 May 2005 16:31:02 -0700, "tooks"
wrote:

I require a formula that will count how many days between two dates.eg
23/05/02 and23/05/03. Using the rcommended formula days360(the two
dates here)gives the answer 1 as in one year.........help meeeee please!


In Excel, dates are stored as serial numbers. So if you want the actual number
of days between two dates, merely subtract one from the other.

A1: 23 May 2002
A2: 23 May 2003

B1: =A2-A1 := 365 (format as General)

=DAYS360(A1,A2) would give a result of 360. This formula is used for certain
accounting system that assume 30 day months.


--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
Formulae, conditional formatting & macro security Kevin Lucas Excel Discussion (Misc queries) 7 March 15th 05 02:10 PM
Excel and CubeCell Formulae les Excel Discussion (Misc queries) 0 March 9th 05 12:28 PM
Autofill Formulae system_d Excel Discussion (Misc queries) 5 March 9th 05 10:55 AM
Formulae when some cells contain #N/A HeatherC Excel Discussion (Misc queries) 6 March 1st 05 02:14 PM
vlookup change column index position - without changing formulae loopyloobyloo Excel Worksheet Functions 1 November 26th 04 02:35 PM


All times are GMT +1. The time now is 11:12 AM.

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"