days and dates - ajit

A

Ajit Munj

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
 
B

Bob Phillips

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

conditional if -ajit 3
conditional formatting - ajit 3
days in month - Ajit 11
Calendar - Ajit 2
Dragging year - Ajit 1
Outlook Express - Ajit 3
Simultaneouly insert of rows or col. - Ajit 1
Copying year 2

Top