#VALUE! error while giving Networkdays formula

[Mouli]

Hi

I have an issue while trying to get a result out of Networkdsays formula.
My date formate is 28.09.2007 (ie, 28 is date, 09 is month and 2007 is year).
It is a system generate report with the above format. I getting an error
message. I have tried installing Analysis ToolPak through Addins. It is not
working some one please help me in resolving this issue

 

[AdamV]

Where you are referring to the cell with the "date" in, Excel does not
realise this is a date and sees only text.
Replace the cell reference with this:
DATE(RIGHT(A1,4),MID(A1,3,2),LEFT(A1,2))

so eg NETWORKDAYS(DATE(RIGHT(A1,4),MID(A1,3,2),LEFT(A1,2)),
DATE(RIGHT(B1,4),MID(B1,3,2),LEFT(B1,2)) )