u/antagog

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.