Display each day of the month
 

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

Display each day of the month
 

"selecting" a month and year on C1 (April-08), ????

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"WH99" wrote in message
...
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.
--
WH99

Display each day of the month
 

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


"Don Guillett" wrote:

"selecting" a month and year on C1 (April-08), ????

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"WH99" wrote in message
...
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.
--
WH99

Display each day of the month
 

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+1DATE(YEAR($A1),MONTH($A1)+1,0),"",A28+1)

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

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

Rick


H99" wrote in message
...
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.
--
WH99


"Don Guillett" wrote:

"selecting" a month and year on C1 (April-08), ????

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"WH99" wrote in message
...
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.
--
WH99

Display each day of the month
 

Rick,
Brilliant, it works great.
Many thanks
--
WH99


"Rick Rothstein (MVP - VB)" wrote:

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+1DATE(YEAR($A1),MONTH($A1)+1,0),"",A28+1)

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

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

Rick


H99" wrote in message
...
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.
--
WH99


"Don Guillett" wrote:

"selecting" a month and year on C1 (April-08), ????

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"WH99" wrote in message
...
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.
--
WH99