Counting Days

[jose]

Hello,

I am creating a work scheduling spreadsheet and I am having some
trouble. I am trying to find the number of working days in a week,
the end of which being Saturday, and the start of which being Sunday
(Day 1). Here is the problem that I am having:

If I have a project that starts on March 20, 2004 (A Saturday), I need
it to record that Saturday as a full day of work. This is a problem
because Saturday is the end of that week so when I subtract the two, I
get zero.

Does anyone know how to count the start date as the first full day of
work. Any help would be greatly appreciated.

Thanks

 

[Jerry W. Lewis]

=IF( MOD(WEEKDAY(<startdate>)-1,6)=0, <formula>+1, <formula>)

Jerry