Allow a cell to equal a value if between two dates
Hi,
Am Mon, 16 Jul 2018 02:05:12 +0100 schrieb NBrugger:
G H I
1
2 Jan 11 Jan 25 Feb 8
3 to to to
4 Jan 24 Feb 7 Feb 21
5
..and repeated to the end of the year.
I would like row 5 to represent the child tax credit income, any time
the 21st of the month falls between (or on) the two dates in the column.
In this scenario, it would be G5 and I5.
try in G5:
=IF(AND(G2<=DATE(YEAR(G2),MONTH(G2),21),G4=DATE(Y EAR(G2),MONTH(G2),21)),AmountOfTax,"")
and drag it to the right.
Regards
Claus B.
--
Windows10
Office 2016
|