PDA

View Full Version : Solved: Apply dates depend on Month/Year



r_know
07-06-2012, 01:43 PM
Dear All,

In E1 Cell, I have drop down to select the months (ie. Jan, Feb) & F1 having year information ie. 2012. Depend selection of month; I want Date of first day to last day for month should be drawn in E2 : to further horizontal row. Format of date DD.MM.YY

Anyone suggest Please.

Regards,

RL
:banghead::banghead::banghead:

xld
07-07-2012, 01:54 AM
E2: =DATEVALUE("01-"&E1&"-"&F1)
F2:AH2: =IF(E2="","",IF(MONTH(E2+1)<>MONTH(E2),"",E2+1))

r_know
07-07-2012, 01:57 AM
Wow,

You always help me. I am very Glad...

Regards,
RL>