| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want a the to display the Month name only. Nothing else. | Setting up and Configuration of Excel | |||
| First day and Last day of the month to display automatically | Excel Discussion (Misc queries) | |||
| Display month name instead of number | Excel Discussion (Misc queries) | |||
| Display Month - 1 | Excel Worksheet Functions | |||
| Display every 3rd category name but still display latest month | Charts and Charting in Excel | |||
Linear Mode
