DateTimeDiff Formula Not Working

MattR79

I am trying to calculate the amount of days between the current date and then determine whether something is out of SLA based on the amount of days difference.  The issue that I am running into is that since I essentially want to exclude weekends then if the current day is Monday or Tuesday the line should be included if the age is >5 and otherwise the line should be included if the age is >2.  Below is the formula I am using and even though today, the day I am writing this, is Tuesday the line is included despite the age being 3.  Any idea on why the formula is not working.  See the formula and the item that is being included in error.

Formula:

if
IsEmpty([Comments]) and
datetimeformat(DateTimeToday(), "%A") = "MONDAY"
and [Age] > 5
then "Y"
elseif
(IsEmpty([Comments])
and
(DateTimeFormat(DateTimeToday(), "%A") = "TUESDAY")
and [Age] > 5)
then "Y"
elseif
IsEmpty([Comments]) and [Age] > 2
then "Y"
else
"N"
endif

Comments	Age
	3

MattR79

See below for some rows of sample data as well as what I would expect to be returned based on a Monday or Tuesday.  Based on what you provided in the image below you are having the same issue as I am.  On the record where the age is 3 I would expect that to have a no as the result due to today being Tues.  I was able to solve the problem by adding another section in the formula where I called out the remaining days of the week specifically, however, I have a few other tools using the same or similar formulas and I'm hoping to not have to do that for all of them.

Input

Client	Comment	Age	Expected Result
Company A		3	N
Company B		5	Y
Company C	Sample Comment	12	N

New Formula:

If
(IsEmpty([Comments]) and [Age] > 4 and (DateTimeFormat(DateTimeToday(), "%A") = "MONDAY" or DateTimeFormat(DateTimeToday(), "%A") = "TUESDAY")) then "Y"
elseif
(IsEmpty([Comments]) and [Age] > 2 and (DateTimeFormat(DateTimeToday(), "%A") = "WEDNESDAY" or DateTimeFormat(DateTimeToday(), "%A") = "THURSDAY" or DateTimeFormat(DateTimeToday(), "%A") = "FRIDAY" or DateTimeFormat(DateTimeToday(), "%A") = "SATURDAY" or DateTimeFormat(DateTimeToday(), "%A") = "SUNDAY")) then "Y"
else
"N" endif