#VALUE! error while giving Networkdays formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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)) )
 
Back
Top