Add decimal Months to A Date

[Aces22]

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

 

[mikerickson]

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?

 

[Aces22]

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

 

[bschwartz]

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.

 

[Aces22]

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!!

 

[bschwartz]

You're welcome.