Please could you share a sample data set so to be able to test this formula and see where it is going wrong.
1 of 1 people found this helpful
If you could provide a sample that would be helpful....
Before that, my biggest concern is the parts coloured purple... that indicates they are parameters, and I can't imagine that you
A) have set up parameters like that
B) even if you did, would want to use parameters like that
Have you ever noticed?
I would have expected the formula to look more like this... (its different bu i hope you get the idea - no purple!)
As mentioned, a sample will help us, help you
Thanks for you pointing out the error in my logic. I set up parameter because at that time I did not know how to compare the dates. I am
very new to these functions.
I tried you formula it works well.
The reason for wrong date range is that I accidently used extracted data which only includes info after 1/Jul/2015.
Thank you for your reply. I learned the date function.