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?