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

P

Pizano3

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?
 
D

Dave F

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
 
P

Pizano3

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
 
Top