what is the code for calender dates?

G

gabe

trying to creater a new calender woandering if there is a way to
automatically fiull in every date withoiut having to manual fill in all of
the 365 days.
 
B

Bob Phillips

Put the start date in A1, then just use =A1+1.

You may get difficulties if you want a grid, say 7 days across. In that
case, assuming that B2:H2 are week 1, then B3 would be =H2+1, C3 would be
B3+1, etc.

--
HTH

Bob Phillips

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