Well, if it matters to you, mine is Friday.
Weeknight.
Friday is a weekday.
It is a weekday
Weekday
The noun 'weekdays' is the plural form. The singular noun is weekday.
One way to determine the day of week based on the date is to use Zeller's congruence. For the Gregorian calendar... int dayofweek (int month, int day, int year) { int weekday; if (month < 3) month += 12; weekday = day; weekday += int ((month + 1) * 26 / 10); weekday += year; weekday += int (year / 4); weekday += 6 * int (year / 100); weekday += int (year / 400); weekday %= 7; return weekday; /* 0 = Sunday, ..., 6 = Saturday */ }
The "at" is superfluous.
As the third input parameter of the IF function, which is what to display if the first input parameter is false, insert another IF function. Example: ="It's " & IF(WEEKDAY(TODAY())=1,"Sunday!",IF(WEEKDAY(TODAY())=2,"Monday!",IF(WEEKDAY(TODAY())=3,"Tuesday!",IF(WEEKDAY(TODAY())=4,"Wednesday!",IF(WEEKDAY(TODAY())=5,"Thursday!",IF(WEEKDAY(TODAY())=6,"Friday!","Saturday!"))))))
if we have to compare .Flights are Tuesdays, Wednesdays, and Thursdays are usually a little bit cheaper .
ESPN broadcasts Sports Center on weekday nights.
It was a Monday.
July 3rd falls on a weekday 71.5% of the time.