date for current month

[apgmin]

in column A1 : through data validation, I have restricted user to select a month ( January, February . . . December )
in column B1 : I need the first date of the month selected in A1
in column C1 : I need the last date of the month selected in A1
in column D1 : I need the 10th date of the month selected in A1

Can please any one help me on how to do it?

 

[Joe4]

Are the dates in B1:D1 always in the current year?
If not, how are we to determine which year to use?

 

[apgmin]

yes sir

 

[Fluff]

How about

=DATE(YEAR(TODAY()),MONTH(A1&1),1)

=DATE(YEAR(TODAY()),MONTH(A1&1),10)

=EOMONTH(DATE(YEAR(TODAY()),MONTH(A1&1),1),0)

 

[Joe4]

OK. Put these formulas in the following cells:

B1:

=DATEVALUE($A1&" 1, "&YEAR(TODAY()))

C1:

=EDATE(DATEVALUE($A1&" 1, "&YEAR(TODAY())),1)-1

D1:

=DATEVALUE($A1&" 10, "&YEAR(TODAY()))

You can then format those cells to show the dates in any date format that you desire.

 

[Joe4]

Actually, we could simplify the formulas I posted for C1 and D1, by making use of what we did in B1 (not need to rebuild a date each time).

So we could use this for C1:

=EDATE(B1,1)-1

and this for D1:

=B1+9