View Single Post
 
Old 02-02-2022, 12:35 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

Either:

a) Define your table on sheet Calendar as Table, and refer to it using Table formula syntax;
or
b) Define the range 'Due_Production_Date_Data' as Dynamic Range,
like:
Due_Production_Date_Data = OFFSET(Calendar!$A$1,1,,COUNT(Calendar!$A:$A),5)
Reply With Quote