Written Date to = Number Date

[mrsbrannon]

Hello all,

Is there a formula that will work for this? I want to type January 2018 into a cell (or two cells - Month/Year) and have another cell populate 1/1/2018.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Month[/TD]
[TD]Year[/TD]
[TD]Date[/TD]
[/TR]
[TR]
[TD]January[/TD]
[TD]2018[/TD]
[TD]1/1/2018[/TD]
[/TR]
</tbody>[/TABLE]


Thanks!

 

[Tetra201]

If you type January 2018 into a cell, it will auto-populate with 1/1/2018.

 

[AhoyNC]

Format cell as date.

Excel Workbook
	A	B	C
1	Month	Year	Date
2	January	2018	1/1/2018
Sheet

 

[mrsbrannon]

That worked!! Thank you!

 

[AhoyNC]

You're welcome. Thanks for the feedback