Using Excel, need to calculate the difference between two dates, excluding
Sundays .

Take a look at this link. Specificaly there is a funciton for counting the
number of Mondays in an interval (you can change it for Sunday). Then it is
just a matter of subtracting the number of sundays from the total number of
days...
--
HTH...

Jim Thomlinson


"gwatt" wrote:

> Using Excel, need to calculate the difference between two dates, excluding
> Sundays .

One way:

A1 = start date
A2 = end date

=A2-A1-SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A2)))=1))

--
Biff
Microsoft Excel MVP


"gwatt" <(E-Mail Removed)> wrote in message
news:BA8F1E2E-B45B-41A4-893C-(E-Mail Removed)...
> Using Excel, need to calculate the difference between two dates, excluding
> Sundays .

Jim, thanks for responding. the function sounds like it will work.
however, I do not see the "link" ? where do I find this function?
Thanks.



"Jim Thomlinson" wrote:

> Take a look at this link. Specificaly there is a funciton for counting the
> number of Mondays in an interval (you can change it for Sunday). Then it is
> just a matter of subtracting the number of sundays from the total number of
> days...
> --
> HTH...
>
> Jim Thomlinson
>
>
> "gwatt" wrote:
>
> > Using Excel, need to calculate the difference between two dates, excluding
> > Sundays .

Or, you could just count all the days that *aren't* Sundays then subtract 1:

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A2)),2)<7))-1

--
Biff
Microsoft Excel MVP


"T. Valko" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> One way:
>
> A1 = start date
> A2 = end date
>
> =A2-A1-SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A2)))=1))
>
> --
> Biff
> Microsoft Excel MVP
>
>
> "gwatt" <(E-Mail Removed)> wrote in message
> news:BA8F1E2E-B45B-41A4-893C-(E-Mail Removed)...
>> Using Excel, need to calculate the difference between two dates,
>> excluding
>> Sundays .
>
>

Try this "daddylonglegs" formula
A1 = start date
B1 = end date

=SUM(INT((WEEKDAY(A1-{2,3,4,5,6,7})+B1-A1)/7))



"gwatt" wrote:

> Using Excel, need to calculate the difference between two dates, excluding
> Sundays .

Great, Thanks. I subtracted one to get the actual day's lapsed.

"Narasimha" wrote:

> Try this "daddylonglegs" formula
> A1 = start date
> B1 = end date
>
> =SUM(INT((WEEKDAY(A1-{2,3,4,5,6,7})+B1-A1)/7))
>
>
>
> "gwatt" wrote:
>
> > Using Excel, need to calculate the difference between two dates, excluding
> > Sundays .