adding days
 

how can I add one-day intervals to cells that are in the date format,
just adding one isn't consistent? I think it has to be a fraction,
similar to adding minutes its 1/1440 for each minute.


--
jcool12
------------------------------------------------------------------------
jcool12's Profile: http://www.excelforum.com/member.php...o&userid=35398
View this thread: http://www.excelforum.com/showthread...hreadid=551704

adding days
 

No, one day is equal to the integer 1, so if you want to add 5 days to a
date

=A1+5

where A1 holds the date



--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"jcool12" wrote in
message ...

how can I add one-day intervals to cells that are in the date format,
just adding one isn't consistent? I think it has to be a fraction,
similar to adding minutes its 1/1440 for each minute.


--
jcool12
------------------------------------------------------------------------
jcool12's Profile:
http://www.excelforum.com/member.php...o&userid=35398
View this thread: http://www.excelforum.com/showthread...hreadid=551704

adding days
 

Yeah, that works for one day, but if you want a seris, like adding one
day for say two years, cell =(previous cell)+1, it doesn't work.
because there is not exactly 365 days in a year.


--
jcool12
------------------------------------------------------------------------
jcool12's Profile: http://www.excelforum.com/member.php...o&userid=35398
View this thread: http://www.excelforum.com/showthread...hreadid=551704

adding days
 

Hi jcool12,

You don't need a formula, Excel does that automatically, just click
and drag the fill handle.

HTH
Martin

adding days
 

But Excel adjusts that automatically, it knows it is a date, and knows how
many days per year.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"jcool12" wrote in
message ...

Yeah, that works for one day, but if you want a seris, like adding one
day for say two years, cell =(previous cell)+1, it doesn't work.
because there is not exactly 365 days in a year.


--
jcool12
------------------------------------------------------------------------
jcool12's Profile:
http://www.excelforum.com/member.php...o&userid=35398
View this thread: http://www.excelforum.com/showthread...hreadid=551704