Hello All,
I am trying to calculate the start date of insurance policies.
Example if I have a column A with values 3,4,6,2,18 (random integer values)...
I need to write a code that would understand the integer value as in terms of 'months ago' the policy started.
Example for integer value as 3 in column A it should calculate February 2012 in column B because currently it is May 2012 and 3 months ago it was February 2012.
Column A Column B
3 February 2012
4 January 2012
6 November 2011 <------2011
2 March 2012
18 November 2008 <------2008
Mind you the oldest policy start date is January 2008.
Thanks for the help.
Cheers guys!
I am trying to calculate the start date of insurance policies.
Example if I have a column A with values 3,4,6,2,18 (random integer values)...
I need to write a code that would understand the integer value as in terms of 'months ago' the policy started.
Example for integer value as 3 in column A it should calculate February 2012 in column B because currently it is May 2012 and 3 months ago it was February 2012.
Column A Column B
3 February 2012
4 January 2012
6 November 2011 <------2011
2 March 2012
18 November 2008 <------2008
Mind you the oldest policy start date is January 2008.
Thanks for the help.
Cheers guys!