Forum home » Delegate support and help forum » Microsoft Excel Training and help » Date
|
|
|
The UK's most regular 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. |
Date
Resolved · Low Priority · Version 2003
Reply Wed 27 May 2009, 16:35Delegate Amy said...
Amy has attended:
Excel Intermediate course
Word Intermediate course
Date
how to calculate expiry date
For upcoming training course dates see: Pricing & availability
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
|