F
Finance Guru
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
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