Converting text to Date to populate Gant & Calendar App.
I have an Allocation sheet where I need the user to choose the month in the "Month" column and the 'Start' populates with the first date of the month and the "End" populates with the last date of the month so I can have a start and finish date to show the resource and Allocation on a Gant and Calendar app. I have tried to use =DATE(YEAR(Month@row), MONTH(Month@row), 1) and =DATE(YEAR(Month@row), MONTH(Month@row) + 1, 1) - 1
but they are formatted as dates. Is there any other way to accomplish this?
Help Article Resources
Check out the Formula Handbook template!