Expert: Richard Roberts - 11/3/2009

Question
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
 



---------- FOLLOW-UP ----------

QUESTION: I apologize for my lack of clarity

I have 12 months on 12 different sheets and I want to be able to
when I go to the first month, put in January 2010   then the 12 sheets will generate numbers based on the year, weekday etc. as they are not next to each other f5, g5, h5 etc.. as it is a calendar format

thank you in advance and my apologies again

Answer
Camron

Okay I think I understand better now--

I don't have the time to create the calendars for you or think thru all of the formulas that will be necessary, but here is how I would approach it.

First I would make use of the formulas that convert dates to weekday, month,day, etc.  then I would use the results of these to calculate what goes in each cell.

I have roughly created the months of January, February, March and I will be happy to send you the workbook if you send me your e-mail.  It isn't intended to be a final product, but it will give you an idea of the types of formulas needed.

Richard