Hi guys
I'm new here and new to excel. I've had a spreadsheet built for me that uses an IF formula so that when we complete a task within 10 days, it pulls through onto another tab as being 100%. If it goes over 10 days, it will pull through as less than 100%.
We have 10 working days to complete a task but with NETWORKDAYS, it counts the first day. Is there anyway I can get it to start counting the day after? T3 shows as 11 days because it counts the day it starts on, but I would like that to equal 10 days. Any suggestions?
Thanks so much in advance! I'm a complete novice here so please go easy on me and let me know if it's helpful for me to provide any further info.
Bookmarks