98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Date
Date
Resolved · Low Priority · Version 2003
Wed 27 May 2009, 16:35Delegate Amy said...
Amy has attended:
Excel Intermediate course
Word Intermediate course
Excel Advanced course
Date
how to calculate expiry date
Thu 28 May 2009, 09:21Trainer Carlos said...
RE: date
Hi Amy
An expiry date is usualy a set number of days from the date of creation.
For example if a Product was made on the 27 May 2009 (stored in Cell "D6" of the Worksheet) and will expire 100 days later then the calculation will be
= D6 +100
The answer will be 4 September 2009 (a date 100 days after the example date).
Hope this helps
Carlos
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Sum Up All the Values in A ColumnIf you want to quickly calculate the Summed values of all cells in a column in Excel 2003 normally you would use the SUM formula. (eg if you wanted to calculate the values in Column C rows 10 to 25) the formula would be: |
