I have two files in the attached workbook that has one file that has badge data and the other file has the neighborhood capacities. In the neighborhood capacities file, there is the original count of employees and contractors in columns F and G. The next two columns are the updated counts of employees and contractors that have been changed on the Change Date in column (J).
In the file, there has been two updates in the employee and contractor counts: one on 2/7/22 and one on 2/10/22. On 2/7/22, the employee count was changed to 25. I was able to get that to change starting on 2/7/22 with this formula:
If [Date]>=[Change Date] then [Updated Contractor Count]+[Updated Employee Count]
Else [Original Headcount]
END
However, I cannot quite figure out the calculation so that it takes into account the second update on 2/10/22, when the employee count was changed to 27. Starting on 2/10/22, the updated headcount should be 27.
Any ideas? Appreciate any help. Thank you
