I’m looking for a formula to help me change the month of a date to a specific month of the year. Say the date is 5/6/19. I want to calculate a date the same day and year but in August. So I need the formula date to be 8/6/19. It would need to work with dates such as 6/12/2019 giving me a date of 8/12/2019.

By: Jennifer