Forum Discussion

StantonSmith's avatar
StantonSmith
Copper Contributor
Sep 05, 2021
Solved

Automatic entries in cells based on a date range

Looking for help creating a formula that will do the following - 

Column A is start date

Column B is an end date

Column C is a number

The rest of the columns are dates that I want the number in column C to be automatically placed if the date falls in the range of columns A and B.

 

Thanks,

Stan

4 Replies

  • StantonSmith 

    Using Excel 365, a single formula

    =IF((day>=startDate)*(day<=endDate),number,"")

    entered into cell D2 will generate the entire 389x352 array.  What use it is, I have no idea.

    • StantonSmith's avatar
      StantonSmith
      Copper Contributor
      thanks! its for showing the amount of people processing over a date range and related to capacities. I know it is "analog" but I like to see the array before summing and making it into a chart.

Resources