# Add decimal Months to A Date

#### Aces22

##### New Member
Hi,

I would like to add a fraction of the month into a given date. Currently using EDATE function will rounddown the number

Example
No of month = 0.5
Start Date = 1-Sep-2014

using edate(1-Sep-2014,0.5) will return 1-Sep-2014 instead of 16-Sep-2014

What function should i use in order to get 16-Sep-2014 (Start Date is fixed)?

Thanks.

Nash

### Excel Facts

Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
How many seconds are there in .5 months?

Or is "half-month" a variable sized unit, 15 days in September, but 15.5 days in January?

How many seconds are there in .5 months?

Or is "half-month" a variable sized unit, 15 days in September, but 15.5 days in January?

Hi Mike,

I would to determine next 20 years planned inspection. OEM has given 1.1 month interval for each inspection starting from 1st Sep 2015.

Thanks

Nash

For PM on equipment, you should probably be using a standard 30 day month, as opposed to a calendar month. So something like this should do the trick:

=DATE(2014,9,1)+1.1*30 where 1.1 is the inspection interval.

For PM on equipment, you should probably be using a standard 30 day month, as opposed to a calendar month. So something like this should do the trick:

=DATE(2014,9,1)+1.1*30 where 1.1 is the inspection interval.

That works. Thanks!!

You're welcome.

Replies
9
Views
104
Replies
3
Views
104
Replies
4
Views
214
Replies
9
Views
248
Replies
6
Views
123

1,196,447
Messages
6,015,316
Members
441,887
Latest member
acquamarine

### 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.

### Which adblocker are you using?

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

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