Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Date formula
I am designing a simple spreadsheet to show a 'next review' date in
excel 97. I have one column showing the last review date (column H) and another column showing the next review date (column K). The formula I have used in cell K1 is =H1+7 which then display the date in cell K1 as 7 days later ie I enter 21/02/05 in cell H1 and cell K1 then shows 28/02/05. I am entering this formula each time I make an entry. How can I format the entire K column to automatically add 7 days without have to enter the formula individually into each cell each time a new entry is added? Thanks Tim ps I am a novice, at best, with excel. |
#2
|
|||
|
|||
In cell K1 enter
=IF(H1="","",H1+7) Using the fill handle (the small cross at the bottom right of the cell), hold your left mouse button down as you drag the mouse down the column as far as you wish to go. -- Regards Roger Govier "Sussex" wrote in message oups.com... I am designing a simple spreadsheet to show a 'next review' date in excel 97. I have one column showing the last review date (column H) and another column showing the next review date (column K). The formula I have used in cell K1 is =H1+7 which then display the date in cell K1 as 7 days later ie I enter 21/02/05 in cell H1 and cell K1 then shows 28/02/05. I am entering this formula each time I make an entry. How can I format the entire K column to automatically add 7 days without have to enter the formula individually into each cell each time a new entry is added? Thanks Tim ps I am a novice, at best, with excel. |
#3
|
|||
|
|||
Thanks Roger.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date Formula | Excel Discussion (Misc queries) | |||
Date formula | Excel Discussion (Misc queries) | |||
Formula to determine a future date based on criteria | Excel Worksheet Functions | |||
Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions | |||
How do I add a date formula to a cell but hide the contents with . | Excel Discussion (Misc queries) |