Thread
:
Formula for determining if two date columns fall within specific date range
View Single Post
#
2
Posted to microsoft.public.excel.misc
Dave O
Posts: n/a
Formula for determining if two date columns fall within specific date range
=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.
Reply With Quote
Formula for determining if two date columns fall within specific date range