Date Difference

  • Thread starter Thread starter stak
  • Start date Start date
S

stak

Hi

Can someone please tell me how to work out the day and
week difference between 2 days.

Eg: Proposed End Date: 20/10/2003
Actual End Date: 20/11/2003

I need to know how many days by which the project has gone
over and then in another cells indicate how many weeks.

Any help would be greatly appreciated. Thanking you in
advance.

Sue
 
Hi Sue!

With Actual end date in B1 and Proposed end date in A1

For days between dates:

=B1-A1
Format General

For weeks between dates:

=(B1-A1)/7
Format General


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Just subtract the smaller from the larger and format as general to get the
number of days.

(There's a function in the analysis toolpak called Networkdays() that will
ignore saturdays and sundays and a list (you type it in) of holidays.)

And divide by 7 and round up/down to get the weeks

or use the =datedif() function.

Chip Pearson has some notes for =datedif() at:
http://www.cpearson.com/excel/datedif.htm
 
Back
Top