That is fantastic! I have been "messing" around with this for well over two hours. Many many years ago in another life I was one answering questions on formulas and very complex macros in Excel...but that was before they even started using VB. But when you stop using a product except for the...
I saw an older post in which median is being used to test between values. I know dates are only values in Excel, but could someone help me with this?!
I have a table of service requests and I need to have a formula to identify in what period the SR falls. So example:
These are the results...