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