A useful Google Sheets formula to increase your productivity


If you work with Google Spreadsheets everyday you must be already familiar with some Google sheets tips and tricks that can improve your productivity and make your life much easier.

If you used MS Excel on-premises software before you must be missing the useful excel formulas for working with GSheets data. Don’t be upset, much of what you liked about Microsoft is now implemented in Google Drive.

If we lived some hundred years ago with no means for improving our life we would have to draw the lines on the wall to calculate the number of days like Robinson Crusoe did. Luckily we live in the modern world where all these actions can be performed by cloud technologies.

In today’s article I am going to tell you about one of my favourite Google sheets formulas that I use in my daily work. This formula will help you to calculate how many days you have left till the vacation.

You need to set up 2 dates in 2 different cells. One will be for today, the other for the day when your vacation will begin (if you have planned it already).

For today use the formula “=TODAY()”. Then the date will change every day.

For calculating the number of days left use the formula:

=DATEDIF(start_date, end_date, unit)

For unit put in “D” to count days.


You can use the same formula to calculate the number of days between any two dates, not only for today.

Google Docs backup

If you share your Google sheets with colleagues of other people out of your organization your data can be erased occasionally or intentionally. To prevent your data from being lost regularly perform Google Docs backup with applications like Upsafe.