On 2002-08-26 06:01, Albert 1 wrote:
B5:
=CHOOSE(A2,"January","February","March","April","May","June","July","August","September","October","November","December")
B6:
=CHOOSE(A2,"January","February","March","April","May","June","July","August","September","October","November","December")&" 1, 2002"
On 2002-08-29 17:25, Lambada wrote:
Thank you! How can I get this one to pick the year from cell AF1
B6:
=CHOOSE(A2,"January","February","March","April","May","June","July","August","September","October","November","December")&" 1, 2002"
Thank you.