I am using a spread sheet to track the date a file is received and date which is equal to the deadline for the file to be completed. That deadline date is equal to 180 days after the file is received. formula to be used on all cells.
Suppose the date the file is received is stored in column A starting with Cell A1. Put the following formula in cell B1: =A1+180 Then right click on the cell B1 and choose Format Cells and select Date as the cell format. Copy this formula down to cell B2 onwards. Now Column B represents the deadline date. Now put the following formula in cell C1: =B1-A1 and copy it down from cell C2 onwards. The file is received after the due date wherever the values in column C are positive. Hope it helps address your query.
Dec 16th, 2014
Are you studying on the go? Check out our FREE app and post questions on the fly!