Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
=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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW TO CALCULATE THE DAYS? | Excel Worksheet Functions | |||
Calculating for number of days when values are in dates | Excel Worksheet Functions | |||
How do I calculate difference in days & hours between two dates e. | Excel Worksheet Functions | |||
Subracting Dates to come up with the # of days between them | Excel Worksheet Functions | |||
calculate with dates before 1-1-1900 | Excel Worksheet Functions |