end value, series will be generated only upto the selected cells. Increment: It is a difference value between the first and second value of your series. So, the next value (Third value) of the series will be generated based on this value. If you want to generate a decreasing order series, negative value should be specified as an increment value.
(i) Generate Even number series from to (ii) Generate a series of , , , ……. upto selected cells. (iii) Generate a series of , , , ,……… (iv) Generate a series of , , …… upto (v) Assume, today is Friday and generate next Fridays (Date series). Self Practice: .
. Date Arithmetic: Manual date calculations can be tricky because you have to keep track of the number of days in a month. In spreadsheets, date calculations become very simple. Here you can add a number to a date and arrive at a new date, find the difference between two dates and use a wide variety of function and formats to get what you want.
For example, enter a date in a cell, say A2. Suppose you want to calculate the date days after this date. To do so, enter the formula, = A2 + , in another cell, say A4. The date appears in the cell.
Type today’s date in first cell. Type your birth date in second cell. Type the following formula in third cell = – reference To Find out how many days you were born? your birth?