# I would like to show work days lapsed from today's date

1. ## I would like to show work days lapsed from today's date

Hello. I would like help with a formula that would calculate work days lapsed using a cell with a start date and a cell with the '=Today()' function.

Thank you.

2. ## Re: I would like to show work days lapsed from today's date

If the start date is in A1, the elapsed workdays is given by

Formula:
`Please Login or Register  to view this content.`

where the third argument is an optional range reference containing a list of dates for weekdays that are non-working days. Please look up Excel Help for NETWORKDAYS for a complete explanation.

3. ## Re: I would like to show work days lapsed from today's date

Thank you so much for the formula. Before I read your reply I tried out the following formula...

=A1-(WORKDAY(E4,5))

Where A1 has '=Today()' and E4 has a starting date and 5 is the number of work days for the week. I will do as you suggest and read up on NETWORKDAYS.

Thank you again!

There are currently 1 users browsing this thread. (0 members and 1 guests)