Sheetsdrill

Level 5: Text and dates Exercise 91 of 92

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 exercise

More exercises in Text and dates