Calculating 26 weeks from start date

[nudepinksnake]

Hi guys,

How can I create a formula that will calculate an end date for a period of 26 weeks when I already have a start date? The 26th week will always end on a friday. however, week one can be defined as any working day.

Thanks in advance!

 

[JoeMo]

Hi guys,

How can I create a formula that will calculate an end date for a period of 26 weeks when I already have a start date? The 26th week will always end on a friday. however, week one can be defined as any working day.

Thanks in advance!

If start date is in cell A1, this should give you the Friday 26 weeks later.

=CHOOSE(WEEKDAY(26*7+A1,1),26*7+A1-2,26*7+A1-3,26*7+A1-4,26*7+A1-5,26*7+A1-6,26*7+A1,26*7+A1-1)

 

[Weaver]

I think this should work, for a date in A2

=A2+7*26+5-WEEKDAY(A2,2)

 

[Teethless mama]

=a1+182-weekday(a1+1)