Add Months in Sequence

[Skybluekid]

Hi All,

I have the below which takes the first date an activity was completed.

GD Task Master.xlsx
	B	C	D	E	F	G
13	Appraisal	29-Jun-22	29-Jun-23	28-Jun-24	28-Jun-25	28-Jun-26
Person View

Cell Formulas
Range	Formula
C13:G13	C13	=SEQUENCE(,5,INDEX(Entry[Date Complete],XMATCH($B$2&B4,Entry[Staff Member]&Entry[Activity],0,-1)),365)
Dynamic array formulas.

What I would like is to add 12 months in the step value. I cant use days as the calculation is not accurate.

 

[Fluff]

How about

=EDATE(INDEX(Entry[Date Complete],XMATCH($B$2&B4,Entry[Staff Member]&Entry[Activity],0,-1)),SEQUENCE(,5,12,12))

 

[GuzmanServices]

or how about the following formula on D13, which may be copied to Cells on the right.

=DATEVALUE(MONTH(C13)&"/"&DAY(C13)&"/"&YEAR(C13)+1)

 

[Skybluekid]

How about

=EDATE(INDEX(Entry[Date Complete],XMATCH($B$2&B4,Entry[Staff Member]&Entry[Activity],0,-1)),SEQUENCE(,5,12,12))

Than#

Thank you @Fluff

 

[Fluff]

You're welcome & thanks for the feedback.