|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 1st, 2008, 08:09 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Figure future date
Is it possible to have cell A1 with todays date and make B1 add 1 week to
that date and display it? 
|
|
#2
August 1st, 2008, 08:11 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Figure future date
=A1+7
-- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "J" wrote in message news  Is it possible to have cell A1 with todays date and make B1 add 1 week to that date and display it?
|
|
#3
August 1st, 2008, 08:18 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Figure future date
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
|
|
#4
August 1st, 2008, 08:49 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Figure future date
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
|
|
#5
August 1st, 2008, 09:46 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Figure future date
=IF(A1"",A1+7,"")
-- __________________________________ HTH Bob "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
|
|
#6
August 1st, 2008, 09:49 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Figure future date
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
|
|
#7
August 2nd, 2008, 03:53 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Figure future date
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
|
|
#8
August 2nd, 2008, 04:35 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Figure future date
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
