Days of month display

[carl]

Would appreciate help with the following;
Upon entering a date (month-year) in a cell i.e. MMM-YY, I require a one column listing of the total days in that month and another column displaying which day of the week relates to the number column in the DDD format. Any ideas?

[MSP77079]

The following function will give you the number of days in the month (date is in cell C3 in this example):

=+DAY(DATE(YEAR(C3), MONTH(C3)+1, DAY(1))-1)

If it's not obvious, what this does is first set the date equal to the first day of "next month", then subtracts one day, then returns what day that is.

The following function will give you text for weekdays (again, the date is in cell C3)
=+CHOOSE(WEEKDAY(C3,1),"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday")

- Pete

[Chandrajit]

Try this formula in teh cells
=DATE(YEAR(B3),MONTH(B3),DAY(0))