Thread: How do I set up a formula for calculating an expiration date?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave F Dave F is offline
external usenet poster
  
Posts: 2,574
Default 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?
Reply With QuoteReply With Quote