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.

Aladin

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

If you need only LABOR DAYS, then use

=NETWORKDAYS(F1,E1)

Juan Pablo

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

THANKS SO MUCH!