ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Date - 12 weeks (https://www.excelbanter.com/excel-worksheet-functions/129531-date-12-weeks.html)

Deb

Date - 12 weeks
 
How do I minus 12 weeks from a starting date?

Thanks for your assistance


T. Valko

Date - 12 weeks
 
Is a week 7 days?

=start_date-84

=A1-84

Biff

"Deb" wrote in message
ups.com...
How do I minus 12 weeks from a starting date?

Thanks for your assistance




Mike

Date - 12 weeks
 
take away 84

=a1-84 where A1 contains a date

"Deb" wrote:

How do I minus 12 weeks from a starting date?

Thanks for your assistance



Deb

Date - 12 weeks
 
thanks everyone...I was trying to make it more complicated then it
really was

On Feb 6, 2:00 pm, Mike wrote:
take away 84

=a1-84 where A1 contains a date



"Deb" wrote:
How do I minus 12 weeks from a starting date?


Thanks for your assistance- Hide quoted text -


- Show quoted text -





All times are GMT +1. The time now is 09:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com