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

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?

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

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


--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Pizano3" wrote:

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?

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

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

"Dave F" wrote:

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


--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Pizano3" wrote:

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?