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: Beg 1-10 mid 11-20 End 21-30 Expacted date for submission Actual Date Formula 12/21/2014 12/21/2014 12/21/2014 Beg Dec 14 End Dec 14 Mid Dec 14 How can i calculate date difference in case of date relate to particular range? Any one can help please. Regards Shehbaz
This question generated 36 answers. To proceed to the answers, click here.
This thread is current as of February 23, 2015.
For more resources for Microsoft Excel:
This article includes the following tags:
- Microsoft Excel