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

Lookup and Reference Examples

  • Create hyperlink with VLOOKUP in Excel
  • How to get first column number in range in Excel
  • How to use Excel TRANSPOSE Function
  • How to get last row in numeric data in Excel
  • Get nth match with INDEX / MATCH in Excel

Data Analysis Examples

  • Data Series in Excel
  • Conditional Formatting Data bars Examples in Excel
  • Subtotal function in Excel
  • Example of COUNTIFS with variable table column in Excel
  • Excel Frequency Function Example

Data Validation Examples

  • Prevent invalid data entering in specific cells
  • Excel Data validation don’t exceed total
  • Excel Data validation only dates between
  • Excel Data validation must begin with
  • Excel Data validation date in next 30 days

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.

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
  • TEXT function: Description, Usage, Syntax, Examples and Explanation
  • RIGHT, RIGHTB functions: Description, Usage, Syntax, Examples and Explanation
  • How to strip protocol and trailing slash from URL in Excel
  • BAHTTEXT function: Description, Usage, Syntax, Examples and Explanation
  • How to abbreviate names or words in Excel
  • Sum through n months in Excel
  • Two ways to sum time over 30 minutes in Excel
  • TIME function: Description, Usage, Syntax, Examples and Explanation
  • Count day of week between dates in Excel
  • Calculate time difference in hours as decimal value in Excel
  • SYD function: Description, Usage, Syntax, Examples and Explanation
  • DOLLARFR function: Description, Usage, Syntax, Examples and Explanation
  • DURATION function: Description, Usage, Syntax, Examples and Explanation
  • How to calculate annuity for interest rate in excel
  • How to calculate annual compound interest schedule in Excel
© 2022 xlsoffice . All Right Reserved. | Teal Smiles