how do I calculate the days between dates?

[Guest]

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!

 

[Peo Sjoblom]

=Cell_with_later_date - Cell_with_earlier_date

format as general


=Cell_with_date + 274

format as date

 

[Guest]

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

 

[Gord Dibben]

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

 

[Peo Sjoblom]

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?

 

[Gord Dibben]

Peo

Around here we use the shotgun method of solving problems.

Wouldn't want to narrow the target range<g>


Gord Dibben Excel MVP

 

[Peo Sjoblom]

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]

Don't miss the spoiled brats at all.

MODO can have them<g>