That is working now for the whole year, however if I add another trip into the same month, it only calculates that last trip and disregards previous days within that month.
for example.
In F9:G9 I have a trip spanning Nov & Dec. So I should return 11 in C32, which I do until I add a 2nd trip in Dec. C32 then disregards the dates in F9:G9 and instead only counts the dates in F10:G10.
Sample (1).xlsx
I'm going to have to ponder this one. Are there any instances that cross over 2 (or more) calendar months?That is working now for the whole year, however if I add another trip into the same month, it only calculates that last trip and disregards previous days within that month.
Please upload a sample workbook more representative of your real data.
Last edited by FlameRetired; 07-18-2024 at 08:14 PM.
Dave
Post #10 has the latest example.
Last edited by AliGW; 07-19-2024 at 02:02 AM. Reason: Please don't quote unnecessarily - use the Quick Reply button instead.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks