Formula help required to get exact date after 2 year

[krjoshi]

Folks,

Please help me for building a formula to get exact date after 2 year from another cell date and the result should start on Sunday always.

i.e : If Type (Column B) Major shutdown Start Date (Column C) is on Friday, December 4, 2015, i want to get start date of Mini Shutdown after 2 years but start on Sunday which is on 10 December, 2017


I have attached the excel workbook of what I am trying to accomplish.

Thanks in advance,

Joshi

[Pete_UK]

You can use this formula in C3:

=DATE(YEAR(C2)+2,MONTH(C2),DAY(C2))+8-WEEKDAY(DATE(YEAR(C2)+2,MONTH(C2),DAY(C2)))

Hope this helps.

Pete

[krjoshi]

Hi Pete,

Awesome.....excellent formula...Thank you so much..

Joshi

[Pete_UK]

You're welcome - thanks for feeding back.

Pete

[JohnTopley]

or

=C2+8-WEEKDAY(EDATE(C2,24),1)