This forum is closed. Thank you for your contributions.

Remove From My Forums

Substitute DATEDIF with NETWORKDAYS

Question
0

Sign in to vote

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

0

Sign in to vote
Hi,

NEYWORKDAYS could not be used in SharePoint. You need to achieve this in other ways.

In the comments of the following article provide us some method. You can refer to it.

http://blog.pentalogic.net/2008/11/working-days-weekdays-holidays-sharepoint-calculated-columns/

Hope this helps.

Thanks.
Pengyu Zhao

TechNet Community Support
- Marked as answer by bosslady1008 Friday, February 10, 2012 3:14 PM
Thursday, February 9, 2012 9:43 AM

All replies

0

Sign in to vote
Hi,

NEYWORKDAYS could not be used in SharePoint. You need to achieve this in other ways.

In the comments of the following article provide us some method. You can refer to it.

http://blog.pentalogic.net/2008/11/working-days-weekdays-holidays-sharepoint-calculated-columns/

Hope this helps.

Thanks.
Pengyu Zhao

TechNet Community Support
- Marked as answer by bosslady1008 Friday, February 10, 2012 3:14 PM
Thursday, February 9, 2012 9:43 AM
0

Sign in to vote

Thank you so much... this helped ALOT!!!!

Friday, February 10, 2012 3:15 PM