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!

=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!

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!

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!

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

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?

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?

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