Hi all and thank you if you are reading this so what i would like to do i have a table of data and in column A i have the date an enquiry was received.
In another column, column M i have a status with the status Failed Credit Check or blank
What i would like is to be able to type in two fields Date From & Date to a date range which would then provide the result ie number of counts of Failed Check for the given date range, obviously i would like to change the date range.
The 2nd element if possible is to have instead of the date range have dropdown to filter on Today, Yesterday, Last 7 Days, Last 30 Days, All
Thank you
In another column, column M i have a status with the status Failed Credit Check or blank
What i would like is to be able to type in two fields Date From & Date to a date range which would then provide the result ie number of counts of Failed Check for the given date range, obviously i would like to change the date range.
The 2nd element if possible is to have instead of the date range have dropdown to filter on Today, Yesterday, Last 7 Days, Last 30 Days, All
Thank you