Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
Conform a total to a list of results? | Excel Discussion (Misc queries) | |||
Macro for changing text to Proper Case | Excel Worksheet Functions | |||
How do I write a formula to color code based on dates provided or. | Excel Worksheet Functions |