Hi All, huge fan of the Excel Forum site here for years in helping me use some fancy formula tricks via the threads of others.
Was wondering if someone has came across creating a formula that calculates the days in dates within two ranges and counting them without the use of a helper column?
Normally, I would create a helper column and do a countifs() but figured if would be cleaner if there was a way to nest a days calculation inside a countif() and read off of that.
I attached a sample .xlsx file for reference.
Any help and insight greatly appreciated!
Thanks,
Linda
Bookmarks