Hello i need a formula to count the number of dates in a column which are 30 days prior, excluding any blanks. I also need it to look at 3 other columns and if there is data in those columns to exculde these from the count as well.
i am trying to count how many letters sent are 30 days old, then would also like to count how many will be thirty days old tomorrow.
letter sent coulumn is N and has a date in the row with a format of 3/22/2012
exclude any rows from the count if there is data in the Row of Column L, T, or X.....
PLEASE HELP, keep getting errors, and dont want to uase a macro as i need to pull this from a shared workbook and multiple tabs
-MATT
Bookmarks