Merge 3 general cells to one date cell [Closed]

Report
-
 visitor -
Hello,
I made a mistake formatting my HUGE tour schedule. I thought I was so smart using 3 cells for dates
a1= 10 (for 2010), a2= month 1-12, and a3= day (1-31). Now that I've found the date calculator function I would like to simply combine cells 1/2/3 to make a date cell 1/31/2010 (I have about 900 dates!).
Can anyone tell me an easy way to accomplish this without hand entering each one?
Thank you!
Kate

1 reply

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
789
suppose
A1 10
B1 1
C1 21

in D1 copy this formula

=DATE(20&A1,B1,C1)

copy D1 down
26
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 5387 users have said thank you to us this month

How do you do this to not include the day - I just need MM/YYYY
Thanks...solved my lingering problem!