P
PJEAN
I am trying to accomplish the following;
If the dates 1 and 2 match or date 2 is earlier than date 1 add 20 points to
the total; if both dates don’t match or the date 2 is later than than date 1
no additional points are added to the total
=IFSUM(I7>M7)=N7+20,(I7)<(I7)=N7+0
CELL
(I7) DATE
(M7) DATE
(N7) SUM TOTAL =SUM(N1:N6)
PJEAN
If the dates 1 and 2 match or date 2 is earlier than date 1 add 20 points to
the total; if both dates don’t match or the date 2 is later than than date 1
no additional points are added to the total
=IFSUM(I7>M7)=N7+20,(I7)<(I7)=N7+0
CELL
(I7) DATE
(M7) DATE
(N7) SUM TOTAL =SUM(N1:N6)
PJEAN