Calculate date from one date

[Dees_Deli]

Hi all

I am trying to calculate a end date from one start date and a certain status
Exp:
If a status is at advertising on 20/11/2023 then the advert should be closed 11 weeks later - what would this date be?
Any help would be greatly appreciated!

 

[Legacy 143009]

Let say the status is in column A and dates are in column B. Then column C formula will be:

=IF(A1="advertising",B1+11*7)

 

[Dees_Deli]

@Flashbond thank you v much this works!

 

[Legacy 143009]

Glad it did help. Thanks for the feedback