Although Google Sheets and Excel Online are two of the best free online spreadsheets editing apps, you may not like certain features of them. For example, the date format. In case you do not want to ...

Google Sheets has the power to calculate the number of days between two dates, regardless of the date format entered. The only requirement is consistency between manually typed dates and the ...

Every time Taylor publishes a story, you’ll get an alert straight to your inbox! Enter your email By clicking “Sign up”, you agree to receive emails from ...

When it's time to set a date, you have a wide variety of options in spreadsheet programs such as Google Sheets and Microsoft Excel. There are essentially three types of dates you can set: dynamic, ...

When you’re parsing through large amounts of data in a Google Sheets spreadsheet, conditional formatting can help you find those bits of information that you want. Conditional formatting helps to ...

This week's tutorial covers a number functions in Google's Spreadsheet app, Google Sheets. Here we take a practical look at using weekdays in calculations, introduce "if" statements and learn how to ...

In Google Sheets, as in other spreadsheet programs, you can set the formatting of a cell (text color, background color) based on the data contained within that cell. This is called "conditional ...

These two keyboard shortcuts will let you insert the current date and time in any cell of your spreadsheet. It doesn’t matter if you are using Google Sheets or Microsoft Excel; you can use these ...

Conditional formatting is used when you want to apply styles to a large number of cells using data within cells to determine how a cell is formatted. Maybe you want to draw attention to dates that are ...