The formula I need assistance with is with the following:
If Column C is equal to text string, and column A is a date within the month of April (1st to 31st) 2011 and column B is any date before the month (not including) April (including prior years), then count the number of instances Column B’s data is a date before the month of april.
Currently the data is in a table so for example Column A is “Invoice Date”, Column B is “Shipping Date”.
If I could get a formula for this that I can modify for every month, EX: replace Column A requirement for May, June, July.. etc and for each month and Shipping Date that would be any date prior to Column A’s Month.
Thanks for the help!
If Column C is equal to text string, and column A is a date within the month of April (1st to 31st) 2011 and column B is any date before the month (not including) April (including prior years), then count the number of instances Column B’s data is a date before the month of april.
Currently the data is in a table so for example Column A is “Invoice Date”, Column B is “Shipping Date”.
If I could get a formula for this that I can modify for every month, EX: replace Column A requirement for May, June, July.. etc and for each month and Shipping Date that would be any date prior to Column A’s Month.
Thanks for the help!