Enter month, get the first date

  • Thread starter Thread starter Gaurav
  • Start date Start date
G

Gaurav

Hi,

I want to be able to select the month from the drop down list and once the
month is selected, I want the first date cell to change itself to the first
date of the month selected. For rest of the date cells I have just used the
formula "First date cell + 1"

any help will be appreciated!!

Thanks a lot in advance.
 
Check your other post.
Hi,

I want to be able to select the month from the drop down list and once the
month is selected, I want the first date cell to change itself to the first
date of the month selected. For rest of the date cells I have just used the
formula "First date cell + 1"

any help will be appreciated!!

Thanks a lot in advance.
Click to expand...
 
A1 has a data validation list of
{Jan,Feb,Mar,Apr,May,June,July,Aug,Sep,Oct,Nov,Dec}
B1 has the formula:
=DATE(2010,MATCH(A1,{"Jan","Feb","Mar","Apr","May","June","July","Aug","Sep","Oct","Nov","Dec"},0),1)and returns the first day of the month specified in A1best wishes--Bernard LiengmeMicrosoft Excel MVPhttp://people.stfx.ca/bliengme"Gaurav" <[email protected]> wrote in messageHi,>> I want to be able to select the month from the drop down list and once themonth is selected, I want the first date cell to change itself to the firstdate of the month selected. For rest of the date cells I have just used theformula "First date cell + 1">> any help will be appreciated!!>> Thanks a lot in advance.>
 
Back
Top