Excel formula question

Statistics
Tutor: None Selected Time limit: 1 Day

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.   

Dec 4th, 2014

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!
Download on the
App Store
...
Dec 4th, 2014
...
Dec 4th, 2014
Dec 9th, 2016
check_circle
Mark as Final Answer
check_circle
Unmark as Final Answer
check_circle
Final Answer

Secure Information

Content will be erased after question is completed.

check_circle
Final Answer