Counting calendar Days - not including Sundays
 

Is there a way to do a formula that returns a count of days remaining in a
month (or specified date range) that doesn't include Sundays?

Ex. Today's Date: =today()
End Date: May 22nd

Formula to calculate how many (Non-Sunday) days left between today and
May 22nd.

This board rocks, thanks in advance for the help!

Counting calendar Days - not including Sundays
 

Look he

http://www.cpearson.com/excel/betternetworkdays.aspx

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"KenCanuck" wrote in message
...
Is there a way to do a formula that returns a count of days remaining in a
month (or specified date range) that doesn't include Sundays?

Ex. Today's Date: =today()
End Date: May 22nd

Formula to calculate how many (Non-Sunday) days left between today and
May 22nd.

This board rocks, thanks in advance for the help!

Counting calendar Days - not including Sundays
 

Try this link...

http://www.cpearson.com/excel/betternetworkdays.aspx
--
HTH...

Jim Thomlinson


"KenCanuck" wrote:

Is there a way to do a formula that returns a count of days remaining in a
month (or specified date range) that doesn't include Sundays?

Ex. Today's Date: =today()
End Date: May 22nd

Formula to calculate how many (Non-Sunday) days left between today and
May 22nd.

This board rocks, thanks in advance for the help!

Counting calendar Days - not including Sundays
 

Try with a future date in A1

=SUM(INT((A1-WEEKDAY(A1+1-{2;3;4;5;6;7})-TODAY()+8)/7))

If this post helps click Yes
---------------
Jacob Skaria


"KenCanuck" wrote:

Is there a way to do a formula that returns a count of days remaining in a
month (or specified date range) that doesn't include Sundays?

Ex. Today's Date: =today()
End Date: May 22nd

Formula to calculate how many (Non-Sunday) days left between today and
May 22nd.

This board rocks, thanks in advance for the help!