Still not 100% clear what happens in this file, for ex...
does the file contain transactions for multiple months ?
do the times cross over months (ie over midnight from one month to another and
if so what happens ?)
if using VBA I would use an open event to post today's date (or 1st of current month) into a cell such that you have a static reference available thereby enabling you to avoid the need for the Volatile dependency in subsequent calcs (to ascertain current month)
so using your sample file... pending answers to above and pending your XL version (assuming pre XL2007)
Obviously in the above we're using hard wired references, you could create a Dynamic Named Range - see the link in my sig. for more info.
Bookmarks