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