Report

Merge 3 general cells to one date cell [Closed]

Ask a question Kate - Last answered on Sep 16, 2017 at 06:32 AM by 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
Helpful
+24
plus moins
suppose
A1 10
B1 1
C1 21

in D1 copy this formula

=DATE(20&A1,B1,C1)

copy D1 down
mike- Nov 5, 2015 at 12:26 PM
How do you do this to not include the day - I just need MM/YYYY
visitor- Sep 16, 2017 at 06:32 AM
Thanks...solved my lingering problem!
Reply

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!