Counting calendar Days - not including Sundays

K

KenCanuck

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!
 
J

Jacob Skaria

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

number of months and days between two dates without approximation 3
Calculating dates to include Saturdays but not Sundays 1
Can I get no of Sundays and working days of the month? 6
adding days from one cell with a date in it to another cell 4
counting weeks in current month. 1
How to calculate with workingdays instead of calendar days 4
Calculate Payment Days and Date 7
Networkdays including sundays 0

Top