Forum Discussion
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. ...
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).
Thank you for your time Hans.
It appears that the cells are appearing as false (I replaced the blank with EX to more easily see how formula is working).
ForgedinFire5100 My previous reply contained a typo. I have corrected it; does it work now?
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
- I have messaged you a link to sample workbook.
Thanks.
