How do I set up a formula for calculating an expiration date?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Let's say I format cell A1 to be used as DATE and cell A2 will be an entry of
specific # of days for expiration then what formula do I place in cell A3 for
expiration day to appear?
 
Just sum the two cells: =A1+B1. Excel intuits that you're adding days to the
date in A1. If A1 = March 1st, 2007 and B1 = 67, C1 = May 7th, 2007.

Dave
 
Dear Dave,
Thank you for your assistance. I meant to include that I did do the
following as you stated but my problem seemes to be that when I copy and
paste this formula to other workbooks I get an error on the "expiration date'
cell that sates: #VALUE!

New York Huh? How cold is it over there?

Best,
Sandi Pizano
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional formatting referencing date of expiration 5
Comparison of columns using Conditional Formatting 3
EOMONTH, TODAY() and Conditional Formatting (Excel 2003) 1
Too Many IF Statements Nesting Error (Excel Formula Loop w/o VBA) 7
Machine-readable passport calculations 7
Difference between two date/time values 5
Date lists 3
Summing data between two date criteria 5

Back
Top