Covert two cell date 2024, Aug into Aug-2024

[slam]

Hi gang - happy Friday!

I have a system that exports dates into two rows starting in column D. Row 1 is the year 2024, and row 2 is the month, August, formatted as General. Is there an easy way to turn these into an actual date in row 3?

Thanks

 

[Joe4]

A valid date requires three pieces:
1. Year
2. Month
3. Day

You can format it any way you like, to hide the day portion (i.e. Aug-2024). But in order for it to be stored as a valid date, it also needs the day piece.
So what day do you want to use? 1, the first day of the month?

 

[etaf]

=DATEVALUE("01/"&D2&"/"&D1)

Book9
	D
1	2024
2	august
3	8/1/24
Sheet1

Cell Formulas
Range	Formula
D3	D3	=DATEVALUE("01/"&D2&"/"&D1)

 

[slam]

Hi

Joe, yes, I should have mentioned that. 1st of month is good.

etaf, thank you for the solution. Perfect!

 

[etaf]

you are welcome

 

[Scott Huish]

If you don't specify the day, Excel will default to 1:

=--(D2 & " " &D1)

Format as date