Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-30-2014, 02:44 PM
Odyssey Odyssey is offline Workdays since Received Windows 8 Workdays since Received Office 2010 64bit
Novice
Workdays since Received
 
Join Date: Nov 2014
Posts: 2
Odyssey is on a distinguished road
Default Workdays since Received

Hi,



I need to add a custom inbox field that calculates the number of working days since the email was received.

I've used..
int(now()-[Received])

This just calculates calendar days. Can it be changed to calculate working day, without needing the developer options.

Thanks for you help.
Reply With Quote
  #2  
Old 12-04-2014, 10:24 PM
Tuph Tuph is offline Workdays since Received Windows XP Workdays since Received Office 2010 32bit
Advanced Beginner
 
Join Date: Dec 2014
Location: Melbourne, Australia
Posts: 31
Tuph is on a distinguished road
Default

Try NETWORKDAYS(int(now()-[Received]))
Reply With Quote
  #3  
Old 12-07-2014, 04:37 PM
Odyssey Odyssey is offline Workdays since Received Windows 8 Workdays since Received Office 2010 64bit
Novice
Workdays since Received
 
Join Date: Nov 2014
Posts: 2
Odyssey is on a distinguished road
Default

NETWORKDAYS isn't a command in the list you can use in Outlook.
It's strange that businesses use Outlook, but Outlook can't tell you by default how many working days since received!

It didn't work,but thanks.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Workdays since Received Sent emails not being received paulmc Outlook 3 07-07-2014 11:19 AM
set daily goal for actual workdays, excluding weekends holidays and days off Brian Reilly Excel 1 01-24-2014 11:56 PM
Charts received corrupted sabrina.najjar Outlook 0 08-16-2012 03:04 AM
Attachment not being received Barry Outlook 0 09-29-2010 08:50 PM
No attachment Received mobdoc Outlook 0 06-04-2008 01:48 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:26 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft