|
In response to
"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"
by
🏳️🌈 judge jones 🏳️🌈
|
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)
|
=DATE(B1,VLOOKUP(A1,Sheet2!A:B,2),1) maybe?
Sheet2:
JAN 1
FEB 2
etc.
|
Responses:
|