Show the next first and last date of a given month from today's date
My tech are allocated the same month every year to have their tools calibrated. I want to be able to show the next first and last date of their month from today's date.
John is assigned January, today's date is 25/12/2022, so I want the first and last date to be: 01/01/2023 and 31/01/2023 shown.
Rob is assigned June, today's date is 15/01/2022, so I want the first and last date to be: 01/06/2022 and 30/06/2022
Please help me with this formula
Help Article Resources
Check out the Formula Handbook template!