Hi,
I have a column with the full name of the month. I created a column named "Date". I'd like to have the the Date column show the date as the first of the month and current year. How could I do this?
Current Data:
| Current Data: | | | Output: | |
| Month | Date | | Month | Date |
| January | | | January | 2020-01-01 |
| February | | | February | 2020-02-01 |
| March | | | March | 2020-03-01 |
| April | | | April | 2020-04-01 |
| May | | | May | 2020-05-01 |
| June | | | June | 2020-06-01 |
| July | | | July | 2020-07-01 |
| August | | | August | 2020-08-01 |
| September | | | September | 2020-09-01 |
| October | | | October | 2020-10-01 |
| November | | | November | 2020-11-01 |
| December | | | December | 2020-12-01 |
Thank you,
- Stuart
