| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
|
|
|
||
|
|
| |
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
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 H99" <(E-Mail Removed)> wrote in message news  0A51321-A58C-48DB-A3A4-(E-Mail Removed)...> 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 >> (E-Mail Removed) >> "WH99" <(E-Mail Removed)> wrote in message >> news:6AB2F043-F491-46DB-87E0-(E-Mail Removed)... >> > 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 >> >> |
|
|
|
|
|||
|
Guest
Posts: n/a
|
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+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 > > > H99" <(E-Mail Removed)> wrote in message > news 0A51321-A58C-48DB-A3A4-(E-Mail Removed)...> > 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 > >> (E-Mail Removed) > >> "WH99" <(E-Mail Removed)> wrote in message > >> news:6AB2F043-F491-46DB-87E0-(E-Mail Removed)... > >> > 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 > >> > >> > > |
|
|
|
|
|||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How do I make the month display on the month view on MS Outlook 20 | Randy | Microsoft Outlook Discussion | 1 | 20th Aug 2009 08:53 PM |
| Formula needed to display month by month data. | =?Utf-8?B?WWVhaHllYWh5ZWFo?= | Microsoft Access Reports | 4 | 26th Oct 2006 06:14 PM |
| Display month not month number in report? | david.isaacks@mail.va.gov | Microsoft Access Reports | 4 | 21st Apr 2006 04:24 PM |
| can i display current month with last years month at same time | =?Utf-8?B?dHJhY3k=?= | Microsoft Outlook Calendar | 1 | 14th Oct 2005 04:01 PM |
| Month([ArrivalDate]) not to display number month | Faio | Microsoft Access | 2 | 8th Jan 2005 12:51 AM |
