Jack-P-Winner Member Apr 26, 2015 #1 How can I write a formula or macro to take the Date in column A and place it in CDE? A C D E 4/19/2015 April 19 2015 Thank you!!! Attachments date formua to ind cells.jpg 157.7 KB · Views: 0
How can I write a formula or macro to take the Date in column A and place it in CDE? A C D E 4/19/2015 April 19 2015 Thank you!!!
azumi Active Member Apr 26, 2015 #2 For Month on C5 : =CHOOSE(MONTH(A5),"January","February","March","April","May","June","July","August","September","October","November","December") or =TEXT(A5,"mmmm") For Day on D5 : =DAY(A5) For Year on E5 : =YEAR(A5)
For Month on C5 : =CHOOSE(MONTH(A5),"January","February","March","April","May","June","July","August","September","October","November","December") or =TEXT(A5,"mmmm") For Day on D5 : =DAY(A5) For Year on E5 : =YEAR(A5)
Jack-P-Winner Member Apr 26, 2015 #3 azumi said: For Month on C5 : =CHOOSE(MONTH(A5),"January","February","March","April","May","June","July","August","September","October","November","December") or =TEXT(A5,"mmmm") For Day on D5 : =DAY(A5) For Year on E5 : =YEAR(A5) Click to expand... PERFECT!!!! Thank you!!!!
azumi said: For Month on C5 : =CHOOSE(MONTH(A5),"January","February","March","April","May","June","July","August","September","October","November","December") or =TEXT(A5,"mmmm") For Day on D5 : =DAY(A5) For Year on E5 : =YEAR(A5) Click to expand... PERFECT!!!! Thank you!!!!