Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • How to reference named range different sheet in Excel
  • Vlookup Examples in Excel
  • How to create dynamic named range with OFFSET in Excel
  • Find Closest Match in Excel Using INDEX, MATCH, ABS and MIN functions
  • How to use Excel VLOOKUP Function

Data Analysis Examples

  • How to Create Thermometer Chart in Excel
  • Use Data Form to input, edit and delete records in Excel
  • What-If Analysis: Scenarios and Goal Seek in Excel
  • Everything about Charts in Excel
  • How to create Checklist in Excel

Data Validation Examples

  • Excel Data validation date in specific year
  • Excel Data validation must begin with
  • Prevent invalid data entering in specific cells
  • Data validation must not exist in list
  • Excel Data validation number multiple 100

Calculate expiration date in Excel

by

If you need to calculate an expiration in the future, you can use a variety of formulas.

See example below;

Formula

=A1+30 // 30 days

Explanation

In the example shown, the formulas used in column D are:

=B5+30 // 30 days
=B5+90 // 90 days
=EOMONTH(B7,0) // end of month
=EDATE(B8,1) // next month
=EOMONTH(B7,0)+1 // 1st of next month
=EDATE(B10,12) // 1 year

Important

In Excel, dates are simply serial numbers. In the standard date system for windows, based on the year 1900, where January 1, 1900 is the number 1. This means that January 1, 2050 is the serial number 54,789.

  • If you are calculating a date n days in the future, you can add days directly as in the first two formulas.
  • An easy way to calculate the 1st day of a month is to use EOMONTH to get the last day of the previous month, then simply add 1 day.
  • If you need an expiration date at the end month, use the EOMONTH function, which returns the last day of the month, n months in the future or past.
  • If you want to count by months, you can use the EDATE function, which returns the same date n months in the future or past.
Worked Example:   Get last weekday in month in Excel
Worked Example:   Find Last Day of the Month in Excel

Post navigation

Previous Post:

Calculate days remaining in Excel

Next Post:

Calculate number of hours between two times 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
  • Extract middle name from full name — Manipulating NAMES in Excel
  • How to get last line in cell in Excel
  • BAHTTEXT function: Description, Usage, Syntax, Examples and Explanation
  • Manipulating text strings using Left, Mid, Right, Len, Substitute in Excel
  • Join cells with comma in Excel
  • EDATE function: Description, Usage, Syntax, Examples and Explanation
  • Get fiscal year from date in Excel
  • Convert decimal seconds to Excel time
  • Check If Two Dates are same month in Excel
  • Get days before a date in Excel
  • How to calculate principal for given period in Excel
  • SYD function: Description, Usage, Syntax, Examples and Explanation
  • Example of Future value of annuity in Excel
  • ODDLYIELD function: Description, Usage, Syntax, Examples and Explanation
  • NPV function: Description, Usage, Syntax, Examples and Explanation
Acronyms, Abbreviations, Initialism & What They Stand For
© 2021 xlsoffice. All Rights Reserved | Teal Smiles