Calculating weeks

[Guest]

I need to calculate 13 weeks back from a date. Please help.

 

[Frank Kabel]

Hi
=A1-7*13
if A1 stores your intial date. And format the resulting cell as 'Date'

 

[duane]

since 13 * 7 = 91, why not take date minus 91

 

[Guest]

Thank you, Frank

Hi
=A1-7*13
if A1 stores your intial date. And format the resulting cell as 'Date'