| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| color code a row by expiration date? | Excel Worksheet Functions | |||
| FORMULA FOR CALCULATING YEARS, DAYS, & MONTHS BETWEEN SEVERAL DATE | Excel Discussion (Misc queries) | |||
| Expiration date based on 5 years and Birth month,day ... | New Users to Excel | |||
| Formula for Calculating a Floating Date | Excel Worksheet Functions | |||
| How do I create an alert of expiration date in Excel? | Excel Discussion (Misc queries) | |||
Hybrid Mode
