Net Working Days Expression?

[#1]

Hi All,

Ineed an expression that does the following:

=(RevenueField/Number of working days in 2012 as of current day)*Total working days in 2012

Does anyone know how to do this? I tried Net Working Days, but couldn't quite get it.

Thanks!!

[swuehl · Accepted solution]

Have you tried:

=RevenueField / NetWorkDays(Yearstart(today()),today() ) *

NetWorkDays(Yearstart(today()),YearEnd(today()) )

If you need to handle holidays, you can add a list of holidays as optional arguments to NetWorkDays().

[#3]

That worked perfectly. Thank you!