Days until the deadline
A Google Sheets formula exercise from Sheetsdrill. Solve it with a formula bar on a live sheet in your browser, and it is checked the moment you submit.
The task
Work out how many days are left from the date in F1 to each deadline. A deadline that has passed shows a negative number. Fill C2 and C3 with formulas that could be filled down.
What this exercise teaches
Subtracting one date from another gives days. In a live sheet the date in F1 would be =TODAY(), and every row would count down by itself.
A hint if you get stuck
Dates are numbers underneath, so the deadline minus the date in F1 is the number of days between them. Lock F1.
Try it now, free, no account needed
Your first 15 exercises on Sheetsdrill are free. Open it on the practice page, solve it, and get instant feedback with a hint. A free account adds the worked solution; Pro unlocks every exercise, timed mode and the certificate.
Open this exerciseMore exercises in Text and dates
- First name with SPLIT
- Join the confirmed names
- Address without gaps
- Valid order IDs
- Pull out the invoice number
- Digits only
- Month label with TEXT
- Full years of service
- Working days with holidays
- Due at the end of next month
- Tidy up pasted names
- Items in a comma list
- Domain of an email address
- Renewal date with EDATE
- Orders placed at the weekend
- Amount inside a sentence
- The part before the @
- Mask an account number
- Ship-by date in working days
- Day of the week as a word
- Flag addresses that are not emails