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"): ...
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...