ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   excel "Networkday" function (https://www.excelbanter.com/excel-worksheet-functions/89369-excel-networkday-function.html)

ADS

excel "Networkday" function
 
How do I assign current calendar date to end_date in order to calculate # of
days worked from hire date to current date?

Ardus Petus

excel "Networkday" function
 
Use TODAY() function

HTH
--
AP

"ADS" a écrit dans le message de news:
...
How do I assign current calendar date to end_date in order to calculate #
of
days worked from hire date to current date?




Bob Phillips

excel "Networkday" function
 
Of course

=NETWORKDAYS(start_date,TODAY())

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"ADS" wrote in message
...
How do I assign current calendar date to end_date in order to calculate #

of
days worked from hire date to current date?





All times are GMT +1. The time now is 10:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com