I have a column [Meeting Date]
which is used to determine [Initial Date]
. The user when creating a new list item, inserts a date for [Meeting Date] which is automatically set to Today's date. [Initial Date] is set to [Meeting Date] + 2
but notice the following formula I used the WEEKDAY formula with the (2) return type to see if the value is a Thursday or Friday to calculate for the weekend/only business days:
[Initial Date] Formula
=IF(
WEEKDAY(
[Meeting Date],
2
) = 5,
[Meeting Date] + 4,
IF(
WEEKDAY(
[Meeting Date],
2
) = 4,
[Meeting Date] + 4,
[Meeting Date] + 2
)
)
The column that I am having issues with is the [Final Date]
combined with the use of another column [Submitted To]
which is a yes/no column. If [Submitted To]
is not checked, then the [Final Date]
is equal to [Initial Date]
column (which already skips over the weekend dates and only accounts for business days). If [Submitted To]
is checked, then [Final Date]
will equal [Initial Date] + 5
. The issue is that if the [Submitted To]
is checked, it does not account for weekends.
[Final Date] Formula (Not accounting for weekends that works
=IF([Submit To PO],IF(ISBLANK([Initial Submission Due Date]),"",[Initial Submission Due Date]+5),[Initial Submission Due Date])
I receive The formula contains a syntax error or is not supported.
when I try the below formula
Please see formula below:
[Final Date] Formula
=IF(
[Submitted To],
IF(
ISBLANK(
[Initial Date]
),
"",
),
IF(
WEEKDAY(
[Initial Date],
2
) = 1,
[Initial Date] + 7
),
IF(
WEEKDAY(
[Initial Date],
2
) = 2,
[Initial Date] + 7
),
IF(
WEEKDAY(
[Initial Date],
2
) = 3,
[Initial Date] + 7
),
IF(
WEEKDAY(
[Initial Date],
2
) = 4,
[Initial Date] + 7
),
IF(
WEEKDAY(
[Initial Date],
2
) = 5,
[Initial Date] + 7
),
[Initial Date]
)