ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   what is the code for calender dates? (https://www.excelbanter.com/excel-discussion-misc-queries/97412-what-code-calender-dates.html)

gabe

what is the code for calender dates?
 
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.

Bob Phillips

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.





All times are GMT +1. The time now is 07:11 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com