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
E2: =DATEVALUE("01-"&E1&"-"&F1)
F2:AH2: =IF(E2="","",IF(MONTH(E2+1)<>MONTH(E2),"",E2+1))
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Wow,
You always help me. I am very Glad...
Regards,
RL>
Posting Permissions
Reply With Quote
