Workday in Excel



Workday in Excel
Use this function to calculate a past or future date based on a starting date and a specified number of days. The function excludes weekends and holidays and can therefore be used to calculate delivery dates or invoice dates..




Microsoft Excel Function
=WORKDAY(StartDate,Days,Holidays)        
                                     
Formatting                                                                                                          
The result will normally be shown as a number which can be formatted to a normal date by using Format,Cells,Number,Date.                         

                                                                             

Content Data

StartDate
Days
Result

1-Jan-16
28
42410
 =WORKDAY(D4,E4)
2-Jan-16
28
10-Feb-16
 =WORKDAY(D5,E5)

Workday in Excel Reviewed by Rupesh on 01:35 Rating: 5

No comments:

All Rights Reserved by Technology from Developers Eye © 2014 - 2015
Powered By Blogger, Designed by Aadics
Disclaimers:: The information provided within this blogsite is for general informational purposes only. While we try to keep the information up-to-date and correct, there are no representations or warranties, express or implied, about the completeness, accuracy, reliability, suitability or availability with respect to the information, products, services, or related graphics contained in this blogsite for any purpose.The author does not assume and hereby disclaims any liability to any party for any loss, damage, or disruption caused by errors or omissions, whether such errors or omissions result from accident, negligence, or any other cause.

Contact Form

Name

Email *

Message *

Powered by Blogger.