How to make a easy calendar in excel using only year and month
information?


--
retrospect
------------------------------------------------------------------------
retrospect's Profile: http://www.excelforum.com/member.php...o&userid=34173
View this thread: http://www.excelforum.com/showthread...hreadid=539396

There are calendars available on Microsoft.com some in Word and some in Excel.
http://office.microsoft.com/en-us/te...653371033.aspx
--
Rae Drysdale


"retrospect" wrote:


How to make a easy calendar in excel using only year and month
information?


--
retrospect
------------------------------------------------------------------------
retrospect's Profile: http://www.excelforum.com/member.php...o&userid=34173
View this thread: http://www.excelforum.com/showthread...hreadid=539396

Thanks for the information, but a have to do the tabel myself using date
functions, variables are year and month, I need formula for that. Can
somebody help me.


--
retrospect
------------------------------------------------------------------------
retrospect's Profile: http://www.excelforum.com/member.php...o&userid=34173
View this thread: http://www.excelforum.com/showthread...hreadid=539396

Not sure exactly what you want, but here's a very simple way to
generate a calendar:

Enter your starting date in cell A1. In cell A2, enter this formula:

=A1+1

Ensure that A1 and A2 are formatted as date in the style you require.
Copy/paste cell A2 down the column to cell A366. You have your calendar
- a list of all the dates for one year beyond your starting date.

Hope this helps.

Pete

I try to be more specific.

Year: .... Month: .....
And if you but in a year and a month, then below forms a calendar:
Monday Thusday Wednesday ...... where the day nr and days name are in
correct place, I must use date functions.

thanks


--
retrospect
------------------------------------------------------------------------
retrospect's Profile: http://www.excelforum.com/member.php...o&userid=34173
View this thread: http://www.excelforum.com/showthread...hreadid=539396

Sounds like a homework assignment.

If you have month and year in separate cells, combine these together.
Find out which day of the week the first of this month falls on by
using the WEEKDAY( ) function, then increment from there.

Hope this helps.

Pete