Calculating the start date of an insurance policy

donimuha

New Member
Joined
May 31, 2012
Messages
5
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!
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
I have the below:

A B
1 3
2 4
3 6
4 2
5 18

I need to get to:

A B C
1 3 February 2012
2 4 January 2012
3 6 November 2011
4 2 March 2012
5 18 November 2010

Thanks!
 
Upvote 0
=edate(now(),-ai10)

Hi again,

I am working on data that was valid for February 2012. So instead of June 2012 how could I change the 'start_date' in my below function to February 2012?

=EDATE(NOW(),-AI10)

I could only take it back a month when I did this:

=EDATE(NOW()-1,-AI10)

Thanks.
 
Upvote 0
why not put the date you want to start from in a cell and reference that cell instead of using Now()
 
Upvote 0
why not put the date you want to start from in a cell and reference that cell instead of using Now()



Hi,

I know that the Now() part can be changed to any date.....I want to change it to April 2012 so EDate(April2012,-A1)
does not seem to work....I tried changing the cell formatting to mmmmyyyy as well....any advice?

Cheers.
 
Upvote 0

Forum statistics

Threads
1,213,520
Messages
6,114,101
Members
448,548
Latest member
harryls

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top