I have got a data set with billings. I want to allocate the revenue by date so if a contract for 12,000 starts on 1/2/2018 and ends on 31/1/2019, the revenue allocated should be 12000/365 and only for the dates 1/2/2018 to 31/1/2019 inclusive. I've got to a certain point with the formula. However if you look at the attached file, the revenue is NOT entered for 1/2/2018 even though the contract starts on that date. Also the revenue entry continues past the start date plus 365 days. I'm now officially googly eyed looking at this formula so I need another few pairs of eyes on it. :-) would appreciate someone telling me what I am missing.. thanks as always..