| |
You are here: Experts > Computing/Technology > Microsoft Software > Excel > re-question
Excel - re-question
Expert: Richard Roberts - 11/2/2009
Question
i questioned this to another expert and i was replied that it was out of their expertise. if it also with you can you forward it to others?
I made a calender with the month on the top, each column sunday- saturday
and the dates are split also in those columns
ie: january 1st 2010 starts on a friday so its in friday column, but
there is many columns in between each date and more are on different rows.
How do I generate dates also including boxes that aren't being used, based on the month, year?
so it auto fills as I change the month and year to auto fill the whole calender with each specific date in the proper columns
Answer
Camron
First let me suggest that you check out the help section, there are many calendar templates available and I'm sure there are some that will fit your purpose.
It is relatively simple to create the calendar based on the start date of 1/1/10 and putting that date in Friday-- in the next day put in the formula (+the cell that has the 1/1/10 date in it +1) in other words all you are doing is taking the existing first date and adding one day.
Assuming that cell is F5, then the formula in cell G5 is +F5+1.
The formula in cell A6 the first Sunday is +G5+1, etc, etc, etc.
Hope this helps
Richard
Florida
USA
Ask a Question
|
|
