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!