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.
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.
Review
Review
24/7 Homework Help
Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science!
Similar Content
Related Tags
We Were Eight Years in Power
by Ta-Nehisi Coates
Shattered - Inside Hillary Clintons Doomed Campaign
by Amie Parnes and Jonathan Allen
Broke Millennial: Stop Scraping by and Get Your Financial Life Together
by Erin Lowry
The Atlantis Gene
by S. A. Beck
Normal People
by Sally Rooney
Principles - Life and Work
by Ray Dalio
The Prince
by Niccolò Machiavelli
Animal Farm
by George Orwell
The Sixth Extinction An Unnatural History
by Elizabeth Kolbert