| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Populate days of the month in a column by checking on date
Is it possible to populate a column with the days of any given month by
checking on a cell reference to a date? For example if A1 contained 2/28/2009 is there a way for the system to populate B1 through B28 with the dates of the month? Then if you changed A1 to 3/31/2009 have it populate B1 through B31 with the dates for March? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| # of days in that month for a selected date | Excel Discussion (Misc queries) | |||
| How to calculate a date: first day of the month after 60 days | Excel Discussion (Misc queries) | |||
| Date glitch? First 12 days of month format differently than the r | Excel Discussion (Misc queries) | |||
| Fomula for number of days on each month from a date range | Excel Discussion (Misc queries) | |||
| If data in one column, take date, add 2 days, and turn the entire column a color... | Excel Discussion (Misc queries) | |||
Threaded Mode
