Skip to main content
Solved

Six-day working week

  • June 27, 2023
  • 1 reply
  • 0 views

Forum|alt.badge.img+2

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.

Best answer by pressGO_design

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)

View original
Did this topic help you find an answer to your question?

1 reply

pressGO_design
Forum|alt.badge.img+19

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)


Reply