Yeah, that made things challenging from both an intuitive and formulaic standpoint. If it's within your power, it might make sense to add a column so that you can have: Start Date, End Date, Days, Charge, Avg/Day. Then again... if you've got something that works, sometimes it's best not to meddle. For now, I'm just relieved we got something to work!
Bookmarks