HOW MANY WORKING DAYS MORE B/W TODAY & MY NEXT PLANNED HOLIDAY ?
Always thinking that how many days more i need to work before my planned holiday trip to my home & enjoy with my friends & relatives .....
Formula
=NETWORKDAYS (STARTDATE,ENDDATE,HOLIDAYS)
While applying this formula you need to mention the Holidays Separately as per the company's holiday list.
For example :your company is off on June 15 [It is my Birthday..:D] & July 6th .You need to mention the holidays list separately.
So You need to work for 47days more from today before your holiday starts .....
Always thinking that how many days more i need to work before my planned holiday trip to my home & enjoy with my friends & relatives .....
Formula
=NETWORKDAYS (STARTDATE,ENDDATE,HOLIDAYS)
While applying this formula you need to mention the Holidays Separately as per the company's holiday list.
For example :your company is off on June 15 [It is my Birthday..:D] & July 6th .You need to mention the holidays list separately.
No comments:
Post a Comment