Rick,
I am not clear on what you want to do.
The number of days between two dates is simply
=end_date - start_date
But what exactly do you mean by the bit about month changes? You can check
if different months with
=IF(MONTH(start_date)<MONTH(end_date),"changed"," ")
--
HTH
RP
(remove nothere from the email address if mailing direct)
"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
|