Hello!
I have a spreadsheet that I am using, where if the requests are "New" I want to find out how old they are. So I subtract the create date from todays date. This is what I have:
=IF([@Status]="new", (TODAY())-[@Created], 0)
Now...I want to take it to the next step and exclude weekends and holidays....how can i do this?
Thank you so much!!!!!
Pearl
Hi Chauhan101,
Try looking at Networkdays function where you have the option to exclude weekends and holiday.. best of luck. thanks.
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
Hello Pearl,
Take a look on NETWORKDAYS function,
=NETWORKDSYS([@Created],TODAY(),Holidays)
Where Holidays is the range your holiday dates. ie H2:H20
=NETWORKDSYS([@Created],TODAY(),H2:H20)
Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks