1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

How do I modify this formula to still give number of days open without a closed date?

Hello, I am working on a excel log at work where we are keeping track of numbers of days a thing is open. (open date, closed date)

Originally, we were calculating all the days of the year, so I found this formula and all was well:

=IF(ISBLANK(T2), TODAY()-B2, T2-B2)

Now, we are changing it to exclude holidays and weekends. After some scouring on the internet I found a formula that works, but nothing to help my next problem.

=T2-B2+1+NETWORKDAYS(B2,T2,Holidays!A2:A8)-NETWORKDAYS(B2,T2)

We still need to track the number of days this thing is open, while it's still open. And this formula doesn't do that, it needs a closed date. I know my original formula was able to do that, but I'm unsure how to apply that to this formula.

I tried doing this but that doesn't seem to work.

=IF(ISBLANK(T2), TODAY()-B2,T2-B2+1+NETWORKDAYS(B2,T2,Holidays!A2:A8)-NETWORKDAYS(B2,T2))

I know I'm doing something wrong and don't know how to get it right.

submitted by /u/DrBitchin
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#AI formula generation techniques
#formula generator
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#rows.com
#Excel
#formula
#open date
#closed date
#days open
#Excel log
#ISBLANK
#TODAY()
#NETWORKDAYS
#formula modification
#holidays
#weekends
#track
#problem