If you need a list of dates in Excel, here are a few options. You can pull a cell down and click Auto Fill Options to see options to fill weekdays, months, or years.
You can also use a simple formula to add to days to a cell with a date in it.
The last option is using the EDATE function. This works well when you want to move forward or backward one or more months from a reference date. Use a positive number to move forward and a negative number to move back.
#excel #dates #workhacks
Негізгі бет Get a list of dates in Excel
Пікірлер