Im working on a template for a budget on excel.
It is divided by month (January, February ect...)
I need help with a formula to display the starting date of each budget month.
For instance:
The year is "2018"
The month is "January"
The first day of that month is "01"
I need a formula te check in the Year cell and see it is 2018
It must then check the Month Cell which will contain text (January, February ect...) and determine the numerical value for that month (January = "01")
Then it must return the starting date for that months budget, for example "01/01/2018" in this case.
Any help will be greatly appreciated please as this is rather urgent.
Bookmarks