Merge 3 general cells to one date cell

Closed

Kate - Jun 10, 2010 at 06:54 PM
visitor - Sep 16, 2017 at 06:32 AM

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

Use the ifs function to return 5 if cell a5 contains the value 3, and return a 6 if it contains any other number.
Gta 5 download apk pc - Download - Action and adventure
Hitman 3 cheats - Guide
If cell contains date then return value ✓ - Excel Forum
Excel formula to check if cell contains a date - Excel Forum
Psiphon 3 download - Download - VPN

1 response

Answer 1 / 1

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Jun 10, 2010 at 09:45 PM

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!

Similar discussions

Excel function question

If cell = date return yes or no.

help me to add particular cells

If a cell contains any text then add a value

Excel: If Date =, then enter a value

Similar discussions

Subscribe To Our Newsletter!