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.