Date, page 2

How to change date format in Excel and create custom formatting

The first part of our tutorial focuses of formatting dates in Excel and explains how to set the default date and time formats, how to change date format in Excel, how to create custom date formatting, and convert your dates to another locale. Continue reading

Using IF function in Excel: formulas for numbers, text, dates, blank cells

In this tutorial, we are going to learn the syntax and common usages of Excel IF function as well as discuss a few formula examples for text, dates and numbers that will hopefully prove helpful both to beginners and experienced Excel users. Continue reading

How to conditionally format dates and time in Excel - built-in rules and formulas

See how to apply Excel conditional formatting to dates. Learn how to use formulas to highlight weekends and holidays, format cells when a value is changed to a date, shade upcoming dates and delays, conditionally format dates based on the current date, and more. Continue reading

Pages: 1 2