formula help

[retrospect]

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

[Rae Drysdale]

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
>
>

[retrospect]

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.

[Pete_UK]

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

[retrospect]

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

[Pete_UK]

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