Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
stucklady!
 
Posts: n/a
Default how do I calculate the days between dates?

okay - I would like to be able to calculate the amount of days between 2
dates, eg, 01/01/2004 and 15/06/2007. I need the answer in days. I also
need to know how to add 'x' amount of days to a date, eg 274 days added to
01/01/2005. Cheeries!
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

=Cell_with_later_date - Cell_with_earlier_date

format as general


=Cell_with_date + 274

format as date

--

Regards,

Peo Sjoblom

"stucklady!" wrote in message
...
okay - I would like to be able to calculate the amount of days between 2
dates, eg, 01/01/2004 and 15/06/2007. I need the answer in days. I also
need to know how to add 'x' amount of days to a date, eg 274 days added to
01/01/2005. Cheeries!



  #3   Report Post  
john86
 
Posts: n/a
Default

Change cells to DD/MM/YYYY HH:MM, 1st cell put date and 00:00 for time, 2nd
cell put end date plus 00:00 then this calculation =(B2*24)-(A1*24)
In 4th cell put=(A3/24), then hide column 3. Hope this helps. Thanks John


"stucklady!" wrote:

okay - I would like to be able to calculate the amount of days between 2
dates, eg, 01/01/2004 and 15/06/2007. I need the answer in days. I also
need to know how to add 'x' amount of days to a date, eg 274 days added to
01/01/2005. Cheeries!

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

stuck

For days between date use the undocumented Datedif Function.

Chip Pearson has info and formulas.

http://www.cpearson.com/excel/datedif.htm

To add 274 days to a date enter the date in a cell then in another cell enter

=cellref + 274

Or just enter =DATEVALUE("01/01/2005") + 274 in a cell and don't use the
helper cell.

Cells must be formatted as Date.


Gord Dibben Excel MVP

On Fri, 11 Feb 2005 13:53:03 -0800, "stucklady!"
wrote:

okay - I would like to be able to calculate the amount of days between 2
dates, eg, 01/01/2004 and 15/06/2007. I need the answer in days. I also
need to know how to add 'x' amount of days to a date, eg 274 days added to
01/01/2005. Cheeries!


  #5   Report Post  
Peo Sjoblom
 
Posts: n/a
Default



For days between date use the undocumented Datedif Function.

Chip Pearson has info and formulas.

http://www.cpearson.com/excel/datedif.htm


Isn't that a tad overkill?

--

Regards,

Peo Sjoblom




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

Peo

Around here we use the shotgun method of solving problems.

Wouldn't want to narrow the target range<g


Gord Dibben Excel MVP

On Fri, 11 Feb 2005 15:27:39 -0700, "Peo Sjoblom" wrote:



For days between date use the undocumented Datedif Function.

Chip Pearson has info and formulas.

http://www.cpearson.com/excel/datedif.htm


Isn't that a tad overkill?


  #7   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

Must be the absence of hockey! <g

--
Regards,

Peo Sjoblom

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



"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Peo

Around here we use the shotgun method of solving problems.

Wouldn't want to narrow the target range<g


Gord Dibben Excel MVP

On Fri, 11 Feb 2005 15:27:39 -0700, "Peo Sjoblom"
wrote:



For days between date use the undocumented Datedif Function.

Chip Pearson has info and formulas.

http://www.cpearson.com/excel/datedif.htm


Isn't that a tad overkill?




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

Don't miss the spoiled brats at all.

MODO can have them<g



On Fri, 11 Feb 2005 18:45:22 -0700, "Peo Sjoblom" wrote:

Must be the absence of hockey! <g


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 TO CALCULATE THE DAYS? Bel Excel Worksheet Functions 2 February 2nd 05 08:05 PM
Calculating for number of days when values are in dates pumper Excel Worksheet Functions 7 January 17th 05 05:52 AM
How do I calculate difference in days & hours between two dates e. probi2 Excel Worksheet Functions 1 January 12th 05 04:59 PM
Subracting Dates to come up with the # of days between them KimberlyC Excel Worksheet Functions 8 December 20th 04 10:46 PM
calculate with dates before 1-1-1900 jan wan Excel Worksheet Functions 3 October 29th 04 10:54 PM


All times are GMT +1. The time now is 06:34 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"