![]() ![]() So we can use the same method to generate date ranges. Now we know that dates are some numbers in Excel. With Excel, we can easily create several sequences. So we can see that multiple date ranges can be built this way. For instance, if we have data in cell A2 and want to use that in cell A1, use =A2 in cell A1, and this will copy the A2 value in A1. Then, we need to copy cell B2 and paste it into cell B3 the relative cell reference Cell Reference Cell reference in excel is referring the other cells to a cell to use its values or properties. When we select cell A3 and type “=B2 + 1.” ![]() If we add a number, say 5, to it, we can build a date range.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |