C3= Start Date
D3= End Date
E3= NETWORKDAYS(C3,D3,M2:M14) where range m2:m14 are holidays
F3=NETWORKDAYS(TODAY(),D3,M2:M14)
G3=Date Completed
How do I stop F3 from counting down after G3 is entered. Please help I want to be done with this file already. TIA.
Hi and welcome to the forum
One way
Formula:
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Use
=NETWORKDAYS(MIN(TODAY(),G3),D3,$M$2:$M$14)
Life's a spreadsheet, Excel!
Say thanks, Click *
Do I enter this in F3?...nEVERMIND I got it!
Last edited by veemarie; 05-05-2015 at 01:42 PM. Reason: resolved my own question
f3=NETWORKDAYS(MIN(G3,TODAY()),D3,M$2:M$14)
try this and copy towards down
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
What do the $ signs do?Originally Posted by nflsales
While copying/dragging formula towards down "M$2:M$14" will remain same.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks