MrExcel Publishing
Your One Stop for Excel Tips & Solutions

HELP calculating dates!!!

Posted by rhonnda jones on October 04, 2001 1:33 PM

It seems that I have tried everything to find a solution to what seemed to be a simple problem. I need to calculate the difference between two dates.
Ex: I have a report and in column E, I have the date the travel report was sent to the provider in column F, I have the date the report was returned to our office. In Column G, I need the number of days it took from the report being sent and received by our office.

Posted by Aladin Akyurek on October 04, 2001 1:39 PM

In G1 enter: =IF(F1,F1-E1,"")

Format G1 as General.


Posted by Juan Pablo on October 04, 2001 1:45 PM

If you need only LABOR DAYS, then use


Juan Pablo

Posted by RHONNDA on October 04, 2001 1:57 PM