Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • How to Use Solver Tool in Excel
  • Conditional Formatting Color Scales Examples in Excel
  • Conflicting Multiple Conditional Formatting Rules in Excel
  • Create Scatter Chart in Excel
  • How To Remove Duplicates In Excel Column Or Row?

References

  • How to use Excel TRANSPOSE Function
  • Two-way lookup with VLOOKUP in Excel
  • Excel Advanced Lookup using Index and Match Functions
  • How to get last row in mixed data with blanks in Excel
  • Complete List of Excel Lookup and Reference Functions, References and Examples

Data Validations

  • Excel Data validation with conditional list
  • Data validation must not exist in list
  • Excel Data validation date in next 30 days
  • Excel Data validation number multiple 100
  • Excel Data validation date in specific year

Display Days until expiration date in Excel

by

This tutorial show how to Display Days until expiration date in Excel using the example below.

To calculate the days until an expiration date, you can use a simple formula based on the TODAY function.

Formula

=A1-TODAY()

Explanation of how this formula works

In the example shown, the formula in C6 is:

=B6-TODAY()

Dates in Excel are simply serial numbers. In the standard date system for Excel, January 1, 1900 is the number 1. January 1, 2017 is 42736, January 1, 2018 is 43101, and  January 1, 2050 is the serial number 54,789.

Worked Example:   Excel Data validation date in specific year

As a result, you can use simple addition and subtraction to calculate dates. In this case, we have a date in the future, so need to subtract the current date to get “days remaining”. The TODAY function returns the current date automatically, so we only need to subtract the result of TODAY() from the date values in column B.

Worked Example:   Count dates in current month in Excel

Note: if a date has passed, the result will be negative.

Worked Example:   Get first Monday before any date in Excel

Creating an expiration date

To create an expiration date, given a date, you can simply add the number of days until expiration. With a date in A1:

=A1+30 // 30 days in the future
=A1+90 // 90 days in the future

Post navigation

Previous Post:

Number and Text Filters Examples in Excel

Next Post:

Convert date string to date time in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • Not Equal To ‘<>‘ operator in Excel
  • IFNA function: Description, Usage, Syntax, Examples and Explanation
  • NOT function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel XOR Function
  • IF, AND, OR and NOT Functions Examples in Excel

Date Time

  • Get month name from date in Excel
  • Sum race time splits in Excel
  • EOMONTH function: Description, Usage, Syntax, Examples and Explanation
  • Count birthdays by month in Excel
  • How to determine year is a leap year in Excel

Grouping

  • Group numbers at uneven intervals in Excel
  • If cell contains one of many things in Excel
  • Group times into unequal buckets in Excel
  • Group arbitrary text values in Excel
  • Running count group by n size in Excel

General

  • Excel Autofill Cell Ranges, Copy, Paste
  • How to get original price from percentage discount in Excel
  • How to Insert Cells, Row and Rows in Excel
  • Basic text sort formula in Excel
  • How to count total columns in range in Excel
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning