[Solved] Add days to a date

cicade · Post by **cicade** » Tue Nov 27, 2007 9:12 am

want to make a series of dates with 14 days between.
so i put in cel b1 date 01-01-2007
then I want in cell b2 to add 14 days (something like =b1+14) but this will not help.
how to add days to a date?
Cicade

Post by **probe1** » Tue Nov 27, 2007 1:32 pm

B2 = B1 + 14 WFM (2.3.1 / Windows), if B1 contains a valid date

Another way:
select the range to fill (including your start date), choose Edit>Fill>Series...
set increment to: 14
set time unit to: Day
hit OK button

Can you make it so?

cicade · Post by **cicade** » Tue Nov 27, 2007 1:39 pm

thanks, very good.

[Solved] Add days to a date

[Solved] Add days to a date

Re: how to add days to a date

Re: how to add days to a date