- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 27, 2023 07:18 AM
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.
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 28, 2023 10:05 AM
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)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 28, 2023 10:05 AM
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)
