J
J
Is it possible to have cell A1 with todays date and make B1 add 1 week to
that date and display it?
that date and display it?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
RagDyer
=A1+7
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?
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?
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?
B
Bob Phillips
=IF(A1<>"",A1+7,"")
R
Rick Rothstein \(MVP - VB\)
What is a "firls"?
I think you want this in B1... IF(A1="","",A1+7)
Rick
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.
In A3 I have 8/1/2008 after using the formula IF(A3="","",A3+7) in B3 I get
39668 displays in the cell.
G
Gord Dibben
Format that number as Date
The 39668 is how Excel computes dates.
Number of days since Jan 0, 1900
See Chip Pearson's site for an explanation and how to work with those serial
numbers.
http://www.cpearson.com/excel/datetime.htm#SerialDates
Gord Dibben MS Excel MVP
The 39668 is how Excel computes dates.
Number of days since Jan 0, 1900
See Chip Pearson's site for an explanation and how to work with those serial
numbers.
http://www.cpearson.com/excel/datetime.htm#SerialDates
Gord Dibben MS Excel MVP