Sequence of days in excel

**In**this lesson, we look at how to use the COUNTIFS function to find rows with duplicate entries in two or more columns. We then use the COUNTIFS function in combination with**Excel's**Conditional Formatting feature to highlight duplicate and triplicate rows. Finding Duplicate Rows - Example data. This lesson uses an example of a product order table.- The formula WEEKDAY returns a number between 1 and 7 that corresponds to a particular
**day****of**the week. With default settings, 1 = Sunday, 2 = Monday, 3 = Tuesday, 4 = Wednesday, 5 = Thursday, 6 = Friday and 7 = Saturday. To count**days****of**week for the date range, for example, to count Fridays in the November holidays (range B2:B5), do one of the following: - Step 1: In this step, we will create a new object called ItemIDSequence that will start with a value of 1 and increment its value by 1. view source print? 1. CREATE
**SEQUENCE**ItemIDSequence. 2. START WITH 1. 3. INCREMENT BY 1; Step 2: In this step, we will create a sample ITEM table with just two columns. - Formula will be: =
**DAY**(EOMONTH (TODAY (),0)) In this formula, instead of referring to a date, we have referred to TODAY in EOMONTH which returns the current date and then EOMONTH returns the last date from the current date's month. In the end,**DAY**returns the**day**number and gets the total number of**days**for the current month. - The -- in front of the LEFT function is a trick we need to play on
**Excel**to force it to treat the result from the LEFT function as a number rather than a text value. It does this by turning it into a negative number then back again (that's what the -- does). The only way**Excel**can do this is convert the text value into a number.