| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
A Year in advance ?
Hello,
I am using Excel 2007 My problem is this, I am entering dates with a renewal date of a year in advance minus 1 day : A1 B1 30/01/08 29/01/09 20/03/08 19/08/09 01/01/08 31/12/08 01/02/09 31/01/10 and so on ..... Presently I am using Vlookup() to put the information into B1,B2,B3,etc automatically,however the date data is getting increasing long. Is there a formulua that I can enter in B1,B2,etc that will achieve this without resorting to Vlookup() All offers of help greatly accepted, and my thanks to all respondents FinanceGuru |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to advance dates by one year then up to 10 yrs in Excel | Excel Worksheet Functions | |||
| Combination Graph with current year and prior year sales | Charts and Charting in Excel | |||
| how to creat a formula to advance date by one year | Excel Worksheet Functions | |||
| how to calculate $1000/year at 5% for 25 years showing each year | Setting up and Configuration of Excel | |||
| How to compare current year to prior year in bar chart? | Charts and Charting in Excel | |||
Threaded Mode
