My boss is having me figure out a formula involving comparing dates, and I'm totally unclear as to where to start because his IF functions and mine haven't been successful. For example, if the date listed in E3 (our "base date") is within the same year as the date in Z2, then the result is the value that is in D3. If the date listed in E3 is not within the same year as the date in Z2, then the result is a blank cell.
Bookmarks