Every 3rd Month

L

Luigi802

New member
Joined
Aug 29, 2016
Messages
12
Reaction score
0
Points
0
Excel Version(s)
2016
I am trying to create a formula which automatically calculates every 3rd month starting with a given date, i.e. 8/2/2016, I'd like it to automatically return 11/2/2016, also then automatically change to 2/2/2017 when 11/2/2016 comes around.........does that make sense?
 
Does this look familiar? ;)

=EDATE(DATE(YEAR(A1),MONTH(A1),1),CHOOSE(MONTH(A1),1,3,2,1,3,2,1,3,2,1,3,2))
 
navic said:
try
Code: 
=EDATE(A1;3)
Click to expand...

Doesn't fit the brief. See the solution I gave in post#2, which was the solution accepted on the other forum, where more details were given. The change of date has to be done on a quarterly basis and it has to return the first of the month.
 
I think that is sulution

suppose that your date is in cell A2
type this formula anywhere
HTML: 
=DATE(YEAR($A$2),MONTH($A$2)+(MOD((ROWS($A$1:A1)-1),3)+1)*3,DAY($A$2))
 
You must log in or register to reply here.
Back
Top