ExcelBanter - days and dates

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - days and dates - ajit (https://www.excelbanter.com/excel-discussion-misc-queries/169050-days-dates-ajit.html)

Ajit Munj

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

Bob Phillips

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

All times are GMT +1. The time now is 04:11 AM.