Using the list of dates from the previous example, let's calculate the number of workdays between two dates with Sunday being the only weekend day. For this, you type number 11 in theweekendargument of your NETWORKDAYS.INTL formula or make a string of six 0's and one 1 ("0000001"): ...
(1) The formula =IF(YEAR(B2+7)=$A$2,B2+7,"") will return 5-digits number instead of date. Please change the 5-digits number to date with selecting and clicking Home > Number Format > Short Date. (2) If you want to list all Fridays of the year, change formula to =DATE(A2,...
Calculate the Day of the Week in Your Head From the Year, Month, and Day Number-days “Number-days” are numbers that are associated with days of the week by a mnemonic. Sunday ≡ NONEday ≡ 0 Monday ≡ ONEday ≡ 1 Tuesday ≡ TWO’Sday ≡ 2 Wednesday ≡ THREE’Sday ≡ 3 (lame...
Using the list of dates from the previous example, let's calculate the number of workdays between two dates with Sunday being the only weekend day. For this, you type number 11 in theweekendargument of your NETWORKDAYS.INTL formula or make a string of six 0's and one 1 ("0000001"): ...