| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
days and dates - ajit
I want excel to fill the days and dates automatically
when I change the month in cell a1 for me. How can I do so? ajit -- Knowldege is Power |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
days and dates - ajit
A1: the nominated month as text, say May
C1: =DATEVALUE("01-"&A1&"-"&YEAR(TODAY())) C2: =IF(OR(C1="",MONTH(C1+1)<MONTH(C1)),"",C1+1) and copy C2 down -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Ajit Munj" wrote in message ... I want excel to fill the days and dates automatically when I change the month in cell a1 for me. How can I do so? ajit -- Knowldege is Power |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calc days between two dates and exclude leap year days | Excel Worksheet Functions | |||
| Conditional Formatting Dates calculating 10 days and 30 days from a certain date | Excel Worksheet Functions | |||
| Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
| count conditional days - ajit | Excel Discussion (Misc queries) | |||
| days in month - Ajit | Excel Discussion (Misc queries) | |||
Linear Mode
