=AND(AND(C1>=A1,C1<=B1),AND(D1>=A1,D1<=B1))
.... returns TRUE when both the criteria begin date and criteria end
date are between employment start and employment end dates.
=AND(AND(C1>=A1,C1<=B1),AND(D1>=A1,D1<=B1))
.... returns TRUE when both the criteria begin date and criteria end
date are between employment start and employment end dates.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks