locked
Substitute DATEDIF with NETWORKDAYS RRS feed

  • Question

  •  

    Please Help!!! Can someone tell me how to substitute DATEDIF with NETWORKDAYS in my formula below? I’m trying not to count weekends and default blanks to today’s day … Can this be done? If not any ideas would be great!

    IF(ISBLANK([Open Date]),0,IF(ISBLANK([Close / Resolve Date]),DATEDIF([Open Date],Today,"d"),DATEDIF([Open Date],[Close / Resolve Date],"d")))
    Tuesday, February 7, 2012 9:50 PM

Answers

All replies