•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Returning Set Dates Through Formulas
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]
Want to read more?
Check out the full article on the original site
Tagged with
#AI formula generation techniques
#formula generator
#rows.com
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#formula
#date
#July 1
#manually entered date
#A1
#B1
#next
#year
#month
#IF
#YEAR
#MONTH
#DAY
#entered