Linking cells that contain dates

L

Lesli

I'm hoping someone can help me...I

I am working in a very basic spreadsheet that I want to track dates. For
instance, column "A" has a list of due dates. I want column "B" to subtract
15 weeks from column "A" so I don't have manually count on a calendar and
enter. Can you please help?

THANKS!!!
 
D

Dodo

I am working in a very basic spreadsheet that I want to track dates.
For instance, column "A" has a list of due dates. I want column "B"
to subtract 15 weeks from column "A" so I don't have manually count on
a calendar and enter. Can you please help?
Click to expand...

In e.g. B2:

=A2-105
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cobditional Formatting Rows based on dates in action plan. 0
Copy addition formula of non-consecutive horizontal cells 2
Mail Merge Directory Conditional Page Break 0
Wrapping a formatted date 0
Email notifications without opening application 1
Create timeline with event being hyperlinks to documents on drive 1
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Assigning a value to one cell based on the date in another... And then doing it again 0

Top