MrExcel.com - Your One Stop for Excel Tips & Solutions

DAYS360() Function

Posted by Shamsuddeen. P.K on December 20, 2001 12:13 PM

The following command works well in excel but it doesn't in VBA


=DAYS360(A1,B1) where, A1 = Date1 and B1 = Date2


Please Help!!!

Posted by Juan Pablo G. on December 20, 2001 12:23 PM

Set a reference to ATPVBAEN.XLA in the references of your proyect. Then you can use:

Ans = Worksheetfunction.Days360(Range("A1"),Range("A2"))

Juan Pablo G.

Posted by Juan Pablo G. on December 20, 2001 12:26 PM

Wait, without the reference it should work, DAYS360 is not in the Analysis ToolPak add in.

Juan Pablo G. Set a reference to ATPVBAEN.XLA in the references of your proyect. Then you can use: Ans = Worksheetfunction.Days360(Range("A1"),Range("A2")) Juan Pablo G. : The following command works well in excel but it doesn't in VBA :

Posted by Shamsuddeen. P.K on December 21, 2001 6:53 AM

It works fine. Thanks a lot