Step 2 Now drag down the cells using the mouse as shown below. Suppose a date 10 August 18 is given in cell B3 and you want to find the month in Excel of the given date in numbers. IF B1.
Add or subtract a combination of days months and years tofrom a date.
Remarks contain the date of completion. In this example were wanting to see the date thats 10 years past an existing date. IF AND A111940A111960A11198U12 All text entries in this example would be placed into column B2. Change the date or time format To change the date or time format right-click on a cell and select Format Cells.