## Forum Discussion

ForgedinFire5100

Dec 31, 2023Copper Contributor

# Fill Cells Based on Date & Num of Days

Simple Gantt Chart filling based off of last day of planned work and amount of days required for said work. Need X to be filled in Columns N:T of the related row. Screenshot attached is example. ...

- Dec 31, 2023
If you want a dynamic array formula, it should be

=IF((N$9:R$9>$H11-$G11)*(N$9:R$9<=$H11), "X", "")

(AND returns a single TRUE/FALSE value, not an array).

All this assumes that N9:R9 contains dates (formatted as d-mmm), and that H11 and down contain dates too (formatted as m/d).

HansVogelaar

MVP

Thank you! The problem is that P7 and hence N9:T9 contain dates in **2024**, but H11, H12 and H13 contain dates in **2023**. If you change the latter to dates in **2024**, the formula will work as intended.

ForgedinFire5100

Jan 01, 2024Copper Contributor

Wow that's embarrassing on my part, formula works as intended now.

You're an absolute Saint! Thank you very very much for the help.

You're an absolute Saint! Thank you very very much for the help.