Dear Sir, I am seeking data formula/function that could calculate the number of days from the expected date to actual date. I can come up with formula to calculate the number of dates between real dates and expected dates. Here is the example parameters:
|Range Definition:||(days of month)|
|Beg 1-10 mid 11-20 End 21-30|
|Expacted date for submission Actual Date Formula|
|Beg Dec 14||9-Dec-14||#VALUE!|
|End Dec 14||18-Dec-14||#VALUE!|
|Mid Dec 14||27-Dec-14||#VALUE!|
This question generated 36 answers. To proceed to the answers, click here.
This thread is current as of February 23, 2015.