Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Six-day working week

Topic Labels: Data Formulas
Solved
Jump to Solution
866 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Migrand
4 - Data Explorer
4 - Data Explorer

Good afternoon! How do I display the number of days in a month in the table, excluding Sunday. There can be as many as four non-working Sundays in a month, as well as five.

1 Solution

Accepted Solutions
pressGO_design
10 - Mercury
10 - Mercury

Assuming that you have the Start Date, the Start Day of the Week, and the number of days in the month, you can use this formula:

IF(OR(AND(Number of Days=31, Start Day=0),AND(Number of Days=31, Start Day=5), AND(Number of Days=31, Start Day=6), AND(Number of Days=30, Start Day=0), AND(Number of Days=30, Start Day=6)), 5, 4)

See Solution in Thread

1 Reply 1
pressGO_design
10 - Mercury
10 - Mercury

Assuming that you have the Start Date, the Start Day of the Week, and the number of days in the month, you can use this formula:

IF(OR(AND(Number of Days=31, Start Day=0),AND(Number of Days=31, Start Day=5), AND(Number of Days=31, Start Day=6), AND(Number of Days=30, Start Day=0), AND(Number of Days=30, Start Day=6)), 5, 4)