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

On Fri, 1 Aug 2008 19:53:00 -0700, J wrote:

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.

"Rick Rothstein (MVP - VB)" wrote:

What is a "firls"?

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

Rick


"J" wrote in message
...
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?

"Lars-Åke Aspelin" wrote:

On Fri, 1 Aug 2008 12:09:23 -0700, J
wrote:

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