View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default what is the code for calender dates?

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)

"gabe" wrote in message
...
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.