I have a date range in one cell and I'm trying to figure out how many days there are from that date to the first of that year. To do that I do the following:
=E2-("01/01/"&YEAR(E2))
That seems to work but I would like to exclude dates a lot like the NETWORKDAYS function allows you to do. It allows you to not count the dates from particular cells if they have passed already thus allowing you to exclude holidays. Any help is more than appreciated, thanks in advance.
Bookmarks