B
Bill Roberts
I write macros for stock analysis using Excel 97. The macro uses the
expression “=NETWORKDAYS(37545,NOW(),0)â€, returning a value of 1654. The
beginning date is 7/22/2002, and the end date is 2/13/2009. Runs just fine.
When I run the macro on a friend’s computer with Excel 2007, it calculates
the same value for networkdays, but it always DROPS 12/9/2009 (Tuesday) and
12/10/2009 (Wednesday). There is definitely stock data for those dates.
Consequently, the beginning date on his computer is 7/18/2002 (2 days
earlier), and the end date is 2/13/2009.
Why does Excel 2007 do that??? TIA.
expression “=NETWORKDAYS(37545,NOW(),0)â€, returning a value of 1654. The
beginning date is 7/22/2002, and the end date is 2/13/2009. Runs just fine.
When I run the macro on a friend’s computer with Excel 2007, it calculates
the same value for networkdays, but it always DROPS 12/9/2009 (Tuesday) and
12/10/2009 (Wednesday). There is definitely stock data for those dates.
Consequently, the beginning date on his computer is 7/18/2002 (2 days
earlier), and the end date is 2/13/2009.
Why does Excel 2007 do that??? TIA.