Forum Discussion

ForgedinFire5100's avatar
ForgedinFire5100
Copper Contributor
Dec 31, 2023

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. ...
  • HansVogelaar's avatar
    HansVogelaar
    Dec 31, 2023

    ForgedinFire5100 

    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).

Share

Resources