Hi,
I'm confused on how I would write an if statement on this issue. I have a cell with e.g. AW018 in cell (D6) and I have dates across rows (2:2). I'm trying to find the value of AW018 (F6:L6) if I use two dates e.g. 11/03/22 to 16/03/22, should equal $8,075.00
Can someone please help how do I write this?
I'm confused on how I would write an if statement on this issue. I have a cell with e.g. AW018 in cell (D6) and I have dates across rows (2:2). I'm trying to find the value of AW018 (F6:L6) if I use two dates e.g. 11/03/22 to 16/03/22, should equal $8,075.00
Can someone please help how do I write this?