So I'm trying to calculate every 3rd month, (quarterly month). For example today is Aug, I want to create a formula where I input any date in Aug (8/1/2016) and it gives me 11/1/2016, also I want it to continue to reciprocate ever 3rd month automatically, like come 11/1/2016 it will then change to 2/1/2016
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Yes that works great, but it doesn't automatically change every 3 months, that's my ultimate goal!
<body id="************" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">
</body><body id="************" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">Yes that works great, but it doesn't automatically change every 3 months, that's my ultimate goal!Yes that works great, but it doesn't automatically change every 3 months, that's my ultimate goal!</body>
Upvote
0
Similar threads
- Solved
