Display each day of the month

W

WH99

On a Worksheet column A1 to A31.
How can I, by selecting a month and year on C1 (April-08), have the days of
the month displaying down column A.
 
W

WH99

If I enter April-08 in cell C1. I then get the whole month of april, from the
1st to the 30th down column A. February would only be 28 days or 29 in leap
years. March would show 31 days. i.e

01-April-08
02-April-08
03-April-08
so on until the end of the month.
 
R

Rick Rothstein \(MVP - VB\)

Assuming C1 contains the real date for the first of the month (formatted to
look like you showed)...

A1: =C1

A2: =A1+1
.....copy A2 down to A28

A29: =IF(A28+1>DATE(YEAR($A1),MONTH($A1)+1,0),"",A28+1)

A30: =IF(A28+2>DATE(YEAR($A1),MONTH($A1)+1,0),"",A28+2)

A31: =IF(A28+3>DATE(YEAR($A1),MONTH($A1)+1,0),"",A28+3)

Rick
 
Top