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. |
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