Excel formula question

User Generated

qlngrf5000

Mathematics

Description

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.   

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

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. 


Anonymous
Just what I needed. Studypool is a lifesaver!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags