Merge 3 general cells to one date cell
Closed
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
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
Related:
- 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
- Psiphon 3 download - Download - VPN
- If cell contains date then return value ✓ - Excel Forum
- If cell A1 has text then cell B2 has today's Date ✓ - Excel Forum
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jun 10, 2010 at 09:45 PM
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
A1 10
B1 1
C1 21
in D1 copy this formula
=DATE(20&A1,B1,C1)
copy D1 down
Nov 5, 2015 at 12:26 PM
Sep 16, 2017 at 06:32 AM