suppose in A1 i have "Jan or 1", in A2 "1" and A3 I have say "2010"..
is there a formula that i can input in A4 that it looks up this three cells that is A1:A3 and give result in MM:DD:YY value???:biggrin:
If anyone knows the formula then Please help!!!