Hi Rick,

You can find all about calculating with dates he

http://www.cpearson.com/excel/datetime.htm#AddingDates

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Crusty" wrote in message
...
Ok, so i have an idea about setting up a workbook but i am using calender
days and i need to have excel count those days. i.e 08/15/2005 -
08/20/2005 =
5 days. now it doesn't matter about weekends and bank holidays. but i do
need
excel to be able to work out month changes.

Is this possible to do and how do you do it?
Extremely grateful

Rick