help needed in creating formulas

[p.bhaskar]

Hi,

I'm using excel 2007.
I'm trying to craete the below formulas in excel.It would be great if you can help me in this.

I have a coulm;say col A; in excel where user will put month like Jan,Feb etc..
Then next coulmn;say col B;will contain day value like 1,2 etc..

How i can create dynamic formula so that
when colA will have month Jan then max day value in ColB should be 31
when colA will have month Apr then max day value in ColB should be 30 etc..

I have another coumn ;say col C; where i need to create dynamic formula in the below way

if a1=jan and b1 =1 then c1 01-jan-2013
if a1=feb and b1 =1 then c1 01-feb-2013
etc..

Thnaks in advance.

[alansidman]

You could do this with data validation based upon cascading (dependent) combo boxes for the months and days.

Look at this link on building these.

http://www.contextures.com/xlDataVal02.html

Then your formula in column c would be =Date(year,month,day)

Look here for help on that: http://www.techonthenet.com/excel/formulas/date.php

Alan

[FDibbins]

Hi p.bhaskar and welcome to the forum

we would love to help you, but 1st, according to forum rule 1, please rename your thread to something more meaningful, that actually describes your problem. lots of contributors will look at a thread title, and if it of interest to them, or falls within their area of expertise, and will only open those threads. also, searching for "help" will not turn up too many results that will benefit you, sorry

when you name a thread, think "google". what kind of returns would you expect if you typed that into google?

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you."