It was a Tuesday.
18th of Novemeber 2011
1 weekday
1 weekday
1 March 1959 was a Sunday.
1 weekday
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!"))))))
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 */ }
New Moon come's out on 21st Novemeber in the US and on the 27th Novemeber in the UK.
#include<stdio.h> void printMonth (int startDay, int days); int main (void) { printfMonth(2,29); return 0; } /*======printMonth===========*/ void printMonth (int startDay, int days) { int weekDay; int dayCount = 0; { printf("Sun Mon Tue Wed Thu Fri Sat\n"); printf("--- --- --- --- --- --- ---\n"); for (weekDay= 0; weekDay < startDay; weekDay++) {printf(" ");} for (int dayCount = 1; dayCount <= days; dayCount++) { if (weekDay > 6) { printf("\n"); weekDay = 1; } else weekDay++; printf("%3d", daycount); } printf("\n--- --- --- --- --- --- ---\n"); return; }}
In the US, that fell on a Friday.
It is a weekday
Friday is a weekday.