Log In
Create Account
SlickerTalk
Search Archives
The Leaderboard
The FAQ
Login
Create Account
Search
Dr. S. Talk
TT/ST Wiki
How Well Do You Know ...
RSS Feed
Hosting by DigitalOcean
Support ST on Ko-Fi
Links Only
50 Results
100 Results
250 Results
500 Results
1000 Results
5000 Results
2 Weeks
2 Months
6 Months
1 Year
2 Years
5 Years
All Time
Live
Down to Post
Backboards:
Live
________________
1: Dec 1, 17:33
2: Dec 1, 11:23
3: Nov 30, 15:54
4: Nov 30, 09:41
5: Nov 29, 16:44
6: Nov 29, 08:01
7: Nov 28, 16:19
8: Nov 28, 09:42
9: Nov 27, 18:07
10: Nov 27, 12:04
11: Nov 27, 08:26
12: Nov 26, 18:06
13: Nov 26, 12:05
14: Nov 26, 08:29
15: Nov 25, 18:33
16: Nov 25, 11:12
17: Nov 25, 07:08
18: Nov 24, 13:17
19: Nov 23, 18:13
20: Nov 23, 06:17
Posts: 164
I have two columns in excel, one with month "JAN" and one with year "2022." how can I easily turn them into a date "1/1/2022" in a new column? thx. -- nm
Posted by
🏳️🌈 judge jones 🏳️🌈 (aka amanda)
Oct 4 '23, 12:07
(No message)
Responses:
Always 1st of the month? =CONCATENATE(MONTH(DATEVALUE(A1&1),"/1/",B1)
-
decline
Oct 4, 12:27
You’d need a way to correlate the text string into the month value in the DATE function I think? Maybe a VLOOKUP to a table in a hidden sheet? -- (edited)
-
znufrii, vice president
Oct 4, 12:16
1
this is what I wound up doing only because using any of the concat options below wouldn't allow me to format result as date. thanks everyone. -- nm
-
🏳️🌈 judge jones 🏳️🌈
Oct 4, 12:50
Format as date and concantenate? -- nm
-
spamlet
Oct 4, 12:14
=DATE(year,month,day) -- nm
-
oblique
Oct 4, 12:13
Post a message
top
Replies are disabled on threads older than 7 days.
