Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Performing date functions after getting cell address
I have two columns in a sheet, approx 1000 rows. A1:A1000 contain the
purchase date (i.e. 1/1/2000). I need to have B1:1000 display the date 3 years from the purchase date. I do not want to add this in manually for each column, so I was hoping there was a way to do something like =date(year(address(row(), column()-1, 4) +3, month(address(row(), column()-1, 4), day(address(row(), column()-1, 4)). In my view, this looks at the year, month, and day for each cell that is in the same row that formula is, and one column to the left. it adds 3 years, and displays the same month and day value. I think I'm close to getting it, but the function errors out. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Performing arithmetic functions to cells with number and text | Excel Discussion (Misc queries) | |||
Cell Size Between Worksheets when performing a copy and paste | Excel Discussion (Misc queries) | |||
Protected cell performing hyperlink | Excel Discussion (Misc queries) | |||
Performing Multiple Functions in a Column | Excel Worksheet Functions | |||
Replace part of link address in a cell with a value(date) from ano | Excel Discussion (Misc queries) |