I want to find a value that corresponds to the date which falls between two dates and also equal to another cell.
sample sheet attached. Table two amount required when table one code and billing date falls between the Valid from and to dates.
I want to find a value that corresponds to the date which falls between two dates and also equal to another cell.
sample sheet attached. Table two amount required when table one code and billing date falls between the Valid from and to dates.
Last edited by bijeesh; 01-18-2021 at 02:30 PM.
Hן
Can you please fill in the amount column manually sop we know what are the expected results?
Thanks.
Also -
In T39 the date in column B is higher than the date in column C
Is it a mistake or on purpose?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks