date

Dates are notoriously finicky to use in spreadsheets. You can’t type them into a formula and expect it to work. However, there are a few different ways to use them in formulas. Once you know how, using dates is much easier. Method 1 – Surround Dates and Times with Quotes For the first example, dates … Read more

How Dates Work Though it may not be obvious initially, spreadsheets store dates as numbers instead of text. You can show dates in many different formats to the user, but their underlying value doesn’t change. To illustrate the concept of the format changing but not the value, all of the rows in this table consist … Read more