Backboards: 
Posts: 164
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 🏳️‍🌈

Always 1st of the month? =CONCATENATE(MONTH(DATEVALUE(A1&1),"/1/",B1)

where A1 = Jan and B1 = 2022

Post a message   top
Replies are disabled on threads older than 7 days.