Forum Discussion

NLepley's avatar
NLepley
Copper Contributor
Dec 06, 2022

Macro formula help

I am trying to create a macro to populate future dates once a location and date are entered into a row. I enter the address and dig date then framing is +15 days from dig date, RI is +35 days from di...
Macros and VBA
Patrick2788's avatar
Patrick2788
Silver Contributor
Dec 06, 2022

NLepley 

If you're using 365 and have access to LAMBDA, this might be an option for you:

 

A Lambda named 'Dig'.  This function creates a dynamic range based on the dates you enter in the dig date column.  You simply provide it with the day intervals (e.g. 15, 35, 110)

=LAMBDA(Framing,RI,House_Close,LET(
    dates, Sheet1!$E$2:$E$1000,
    nonblanks, COUNTA(dates),
    dig, TAKE(dates, nonblanks),
    dig + HSTACK(Framing, RI, House_Close)
))

At the sheet level, the formula is simple:

=Dig(15,35,110)

 

Resources