Date

Resolved · Low Priority · Version 2003

Wed 27 May 2009, 16:35 Delegate 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:21 Trainer 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 courses

	98.8 % recommend us
	More live stats...

Training information:

Excel tip:

Sum Up All the Values in A Column

If 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:

=SUM(C10:C25)

However, if you keep adding values to column C you would keep having to modify the above SUM formula which can get quite annoying.

To get around this you can sum all the values in a column using the following formula:

=SUM(COLUMN:COLUMN)

Which, in our example, would be:

=SUM(C:C)

NOTE You cannot place this formula in column C, or else Excel 2003 will show a circular reference error.

The formula must be placed in any other column, EXCEPT the one being calculated.