only when you select the series type as “Date” Day : To generate date series day-wise Weekday : To generate date series weekday-wise Month : To generate date series month-wise Year : To generate date series year-wise Start Value: Initial value of the series should be typed End Value: End value of the series should be typed If you fail to specify the end value, series will be generated upto the selected cells. Figure . Fill series dialog box If your selection is less than the specified end value, series will be generated only upto the selected cells. Increment: It is a middle 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. Chapter (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 = – refernce Find out how many days you were