Making a calendar in Excel 15

[Zelandakh]

You key in June 2002 into a cell. Or whatever month you like.

Across the top is puts the month. Under that is Sunday, Monday, ..., Saturday (always this order).
Under those, Excel works out where to put 1, 2, 3 etc up to the right number of days for the month.

Each week should be on a row, there should be 5 blank rows between weeks and conditional formatting to hide the days at the end of the month is allowed.

So I have the days from 1st of month in a column, I know I need a weekday() function and I know it can't be THAT difficult.

I'm just having a mental block...someone tell me its Friday!!!!

 

[Avdotcom]

This is exactly what I've needed for a long time!
Thank you very much.

 

[Dreamboat]

Please!

I'm finally setting up my new web at

http://www.TheOfficeExperts.com

and will have freebie downloads available there.

I'll be happy to make anybody's calendars or other workbooks a free download! Anne Troy

http://www.TheWordExpert.com

http://www.Brainbench.com

 

[jokjoh]

Hi,
I wolud really appreciate if you can send the file to me.
Thank you.

 

[mbarron]

My version (and the fromulas) is still available at:

http://www.geocities.com/vonbarron1/index.htm

I could also have one that shows the entire year, all you need to supply is the year.

Mike

 

[SkipVought]

How to set up a calendar in Excel with 3 formulas!

1. Enter your Sun-Sat day headings

2. Using the Name Box, define 5 named cells:
StartDate - This is where the user enters the Calendar Start Date
StartCell - This is the cell just below Sun
SkipRows - Enter the number of rows to skip between weeks
StartCol - =MOD(StartDate,7)+COLUMN(StartCell)-1
StartRow - =ROW(StartCell)

3. Paste this formula in the calendar cells

=IF(MOD((ROW()-StartRow),SkipRows+1)=0,IF(AND(ROW()=StartRow,COLUMN()<StartCol),&quot;&quot;,StartDate+((INT((ROW()-StartRow)/(SkipRows+1)))*7+COLUMN()-StartCol)),&quot;&quot;)

VOLA!

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[alsoknownas]

http://www.geocities.com/vonbarron1/calendar/calendar.zip

[/tt]