very quick question about linking cells

[AFST]

In cell A1 I have a drop down box that displays a month and year. The default format of the date from the drop down is always the last day of the month at 1159PM. So an example is 31-Aug-2011 11:59PM. What I want in cell A2 is something that automatically show the first possible time of the month based on whatever month was picked in A1. So to follow the example A2 should return 01-Aug-2011 12:00AM.

Can anybody help me out?

 

[AlphaFrog]

This will take the month and year from A1 and return the 1st day of the month. Format the cell with this formula with any date-time format you want.

<br /><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>A</th><th>B</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style="text-align: right;;">14-Aug-11 11:59 PM</td><td style="text-align: right;;">01-Aug-11 12:00 AM</td></tr></tbody></table><br /><br /><table cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #A6AAB6"><thead><tr style=" background-color: #E0E0F0;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">B1</th><td style="text-align:left">=DATE(<font color="Blue">YEAR(<font color="Red">A1</font>),MONTH(<font color="Red">A1</font>),1</font>)</td></tr></tbody></table></td></tr></table><br />

 

[AFST]

Perfect. Thank you my friend.

Just thought of another sort of related question. In my A1 where the drop down box is, is there anyway to have the box always default to today but allow for a manual manipulation (say I wanted to select May 2011 instead) if required?