I want the difference between the Resigned date and Joining date; if I use
the formula B1-A1, I get the correct answer in the General number format. But
if I use the date format it is showing one month in excess.
Eg:

A B C
28/05/1996 12/08/2008 =16/03/12 (B1-A1)

B1-A1 will give you 4459 as answer in General number format which is
correct, whereas date format will give you 16/03/12 as answer which is one
month excess.

Hope this clarifiaction is quite ok. please help....
--
Geo


"Ron Rosenfeld" wrote:

On Mon, 11 Aug 2008 22:01:01 -0700, Geo wrote:

Thanks for the effort, let me try to clarify. Say, I would like to calculate
the final settlement of a staff and the details are as follows. Also, for
calculating the settlement I think there is no need for the list of holidays.

A B C
D E
1 Joining Date Resigned Date Total Days worked Basic Salary
Settlement Amnt.
2 dd/mm/yy dd/mm/yy dd/mm/yy 1000.00
=(c2*(365/30))*(d2/30)
--
Geo

That is not sufficient detail to be able to advise you.

If you want the number of weekdays between Joining and Resigned, take a look at
the NETWORKDAYS function which counts M-F only.

If you want something else, you are really going to have to supply more
information.
--ron