Help required in date lookup

[mosh]

Hi all,

I basically have three cell values (month 1 of a quarter, month 2 etc). I have created a dropdown with values; Q1 2008, Q2 2008 etc.

So for example, when Q1 2008 is selected, the first cell is to change to 01/01/2008, second cell to 01/02/2008 (based on the quarterly combo value).

I'm thinking an IF is required but not sure how to implement it especially since how would the IF statement pick up the first month of the quarter.

Thanks for your help.

Regards,
________
Medical Marijuana Dispensary Hillcrest

 

[Brianwarnock]

Assume your lookup list is in A1 and your cells are B1 to B3

B1 would have the formula =Date(Right(A1,4),1,1)
B2 would be =Date(Year(B1),Month(B1)+1,1)
B3 etc

Brian