Figure future date

J

J

Is it possible to have cell A1 with todays date and make B1 add 1 week to
that date and display it?
 
L

Lars-Åke Aspelin

Is it possible to have cell A1 with todays date and make B1 add 1 week to
that date and display it?
Click to expand...


Try the following formula in cell A1

=TODAY()

and the following formula in cell B1

=A1+7

Hope this helps / Lars-Åke
 
J

J

Thanks that works.
Do youi know what formula I can put in other rows that will cause the firls
to stay empty until I add the current date in row 1?
 
R

Rick Rothstein \(MVP - VB\)

What is a "firls"?

I think you want this in B1... IF(A1="","",A1+7)

Rick
 
J

J

I entered the formula and I get a strange number.
In A3 I have 8/1/2008 after using the formula IF(A3="","",A3+7) in B3 I get
39668 displays in the cell.
 

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

Show value from one cell in another cell if today falls between a date range 5
Display weeks from a Milestone 0
need help in creating a formula 1
How do I post date a letter? 1
Function to Return a Date Value Q 4
can a cell be both input and output? 3
Calculate elapsed time excluding specific timeframe 10
Formula not being Friendly 3

Top