The SEQUENCE function generates a list of sequential numbers in an array. We can generate a list of sequential numbers in rows, columns, or both. By default, the SEQUENCE function will return multiple values, which will be placed in the neighboring cells (to the bottom and/or to the right). I.e., we are dealing with dynamic array formulas here. The syntax of the SEQUENCE function is as follows: =SEQUENCE ( rows ; [columns] ; [start] ; [step] ) Rows specifies …
Tag: EOMONTH function
EOMONTH function: calculate past or future date from the starting date
You will sometimes need to calculate one date based on another date. Most often, you will need the first or last date of the current month, the first or last date of the current year, the previous or future month, year, quarter dates, etc. No matter what kind of dates you need, the simplest way to generate them will include the EOMONTH function. The EOMONTH function returns the last day of the month in relation to the start date. …
Line breaks in Excel
A line break is the termination of one line of text, and the beginning of the next line. If needed inside of a single Excel cell, line breaks can be achieved in two ways: the Wrap Text feature allows you to make text appear to be structured into multiple lines, manual line breaks can be entered by pressing Alt + Enter. Consider the following sentence: As of Unicode version 14.0, there are 144,697 characters with code points, covering 159 …
Combine EOMONTH with SEQUENCE: generate a sequence of dates
You will sometimes need to generate a sequence of dates in Excel. Most often, you will need month-end dates, but no matter what kind of dates you need, the simplest way to generate them will include the EOMONTH function combined with the SEQUENCE function. The EOMONTH function returns the last day of the month in relation to the start date. The EOMONTH function syntax is as follows: = EOMONTH ( start_date; number of months ) The start date is …