You will see rectangular black thick box. You will see the cursor symbol changing to the symbol shown in the below screenshot. In the worksheet above we listed AGM-related tasks in Column A.
The DATEDIF formula takes two date cells and calculates the days between them.
If you want to see the serial number in date format change to date. Finally the DATE function then combines these three values into a date thats 3 years in the future 020822. Select a blank cell next to the dates you want to select D17 for instance and enter this formula TODAY 7 now you get the date which is later 7 days from today See screenshot. Select D2 cell by using mouse.