Excel Dates

Hi,
I was shown how to add dates on Excel, by which i mean if i have a date in one box eg. 15th May 2009 i can enter a formula to add dates onto the date eg. =K3+7, except its not working for me, it is coming up with an #VALUE! error.
Can you please advise?
Thanks
Fi

RE: Excel Dates

Thank you for your fast response.
i did this and it says
"Symptom
Excel displays the #VALUE! error in one or more cells in a worksheet.

Causes
One or more cells that are included in a formula contain text, and your formula performs math on those cells by using the standard arithmetic operators (+, -, *, and /).
For example, the formula =A1+B1, where A1 contains the string "Hello" and B1 contains the number 3, returns the #VALUE! error.

A formula that uses a math function, such as SUM, PRODUCT, or QUOTIENT, contains an argument that is a text string instead of a number.
For example, the formula PRODUCT(3,"Hello") returns the #VALUE! error because the PRODUCT function requires numbers as arguments.

Your workbook uses a data connection, and that connection is unavailable.
Example
When you copy the example data to a blank worksheet, the formulas in cells A4 and A5 return a #VALUE! error; however, cells A6 and A7 return the correct value of 30."

which goes against what i did in my training course and what i was told.
Thanks
fi

RE: Excel Dates

Hi Amanda,
Thanks, i have just sent it over to you
Fi

RE: Excel Dates

thank you. i knew i was forgetting something :)