# Calculating 26 weeks from start date

#### nudepinksnake

##### New Member
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.

### Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

#### JoeMo

##### MrExcel MVP
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.

If start date is in cell A1, this should give you the Friday 26 weeks later.
Code:
``=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

##### Well-known Member
I think this should work, for a date in A2

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

#### Teethless mama

##### Board Regular
=a1+182-weekday(a1+1)

1,106,855
Messages
5,513,805
Members
408,971
Latest member
kay_dee8