Date Difference

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
 
N

Norman Harker

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
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
D

Dave Peterson

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
 
Top