Forum Discussion
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 c...
In D2:
=IF(AND(D$1>=$A2,D$1<=$B2),$C2,"")
Fill down and to the right (or vice versa).
See the attached workbook.
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.
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.