•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Returning Set Dates Through Formulas
Our take
If you're looking to return the next July 1 based on a manually entered date in A1, you're on the right track with formulas. The challenge lies in creating a formula that accurately identifies the next occurrence of July 1 after the specified date. To achieve this, consider using the following formula: `=DATE(YEAR(A1) + (MONTH(A1) > 7), 7, 1)`. This will ensure that if the date is after July, it calculates for the next year. Explore this approach to simplify your date management!
I'm trying to figure out a formula but am not sure if it's even possible...
- A1 = manually entered date (mo/day/year)
- B1 = returns the next July 1 (formula needed)
- Example dates:
- A1 = 9/1/2025; B1 = 7/1/2026
- A1 = 4/2/2026; B1 = 7/1/2026
I've used =IF(Q118="","",DATE(YEAR(Q118)+2,MONTH(Q118),DAY(Q118))) in a different area but this formula returns A1+2 years and as A1 has no set input, I can't add months.
Thoughts? Thank you.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience