# Week, day of the week

### Day of the Week in EXCEL

Determine the day of week for a given date in the cell. There are several solutions depending on the result we want to obtain: the day of the week (1 - Mon 2 - Tue, ...) and text form (Monday, Tuesday, ...) or you can simply change the cell format.

### EXCEL Functions: WEEKDAY

WEEKDAY(), the English version of the WEEKDAY(), insuradet day of the week corresponding to the date. Default day of the week is determined as an integer between 1 (Sunday) to 7 (Saturday).

### EXCEL Functions: WEEKNUM

WEEKNUM(), English version of WEEKNUM (), returns a number that indicates what week of the year accounts for the specified date.

### Count the number of weekends between two dates in Excel

Calculate the number of days contained in the date range. Dates entered in worksheet cells. Weekend days are Saturday and Sunday (holidays not included).

### Finding the date of nearest Saturday in EXCEL

Determine the date of the next Saturday before a specified day. Ie if today 25.11.2014 (Tuesday), the nearest last Saturday - 22.11.2014. Also define the date nearest Saturday after a specified day, and just date is the nearest Saturday.

### Highlight Specific Days of the Week in EXCEL

using Conditional formatting to highlight the background of cells containing days of the week Saturday and Sunday, red.

### Last Tuesday in month in EXCEL

Define the last Tuesday of the month, the last Friday or last Wednesday.

### Monday or Sunday of the current week in EXCEL

Define Monday or Sunday of the current week. A week will set a date.

### Get First Monday in a month in EXCEL (Inverse problem)

given date 01/03/2011. Write a formula to determine which order is the day of the week in this month. Answer: the first Tuesday of March.

### Get First Monday in a month in EXCEL

Define the date on which the account first Tuesday of the month, the second Friday or third Wednesday of the month.

### Last Day in a Week Number in EXCEL

If you know the week number, you can find the date of the last day of this week.

### Get Quarter Number from Date in EXCEL

There are 2 ways of determining week numbers: in line with ISO standard and using functions WEEKNUM().