hi guys

how do I get cell C1 to say "0" if the dates in A1 and B1 are the same.

....But if they r not the same and B1 is a later date than A1 then I want the number of workdays between those dates to be displayed as a negative number. i..e
If

A1=20 Sept 07
B1=24Sept 07

I want cell C1 = -3 (as a negative number) (which is the number of workdays difference between those dates).

However, if

A1 = 24 Sept 07
B1 = 20 Sept 07

I want C1 = 3 (as a positive number) (which is the number of workdays difference between those dates).

This is all so that I can get a sum of all the workdays differences between a number of dates in another cell (somewhere else in the spreadsheet) to indicate whether a certain task/project is x number of days behind or ahead of schedule.

Thanks for taking time out to read this. Awaiting your kind response.

Regards