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
