Here's the formula i have, and i'm obviously doing something wrong.
i have column with a name, then one with the date.
first thing i want to do is count up the number of names, but *only* in a specific date range(formula here is between today and next friday)
here's the formula that isn't working
=COUNTIF((Nov02!F1:F1000,"Brian*")*(Nov02!G3:G1000>"11/01/02)*(Nov02!G3:G1000<"11/08/02"))
i tried subsituting the sumproduct function and had no luck.
the other thing i'm trying to do(separate from above)
is try to automatically insert todays date(i don't want it to change to tomorrow, tomorrow when i open it) in column g when i type a name in column f.
i have column with a name, then one with the date.
first thing i want to do is count up the number of names, but *only* in a specific date range(formula here is between today and next friday)
here's the formula that isn't working
=COUNTIF((Nov02!F1:F1000,"Brian*")*(Nov02!G3:G1000>"11/01/02)*(Nov02!G3:G1000<"11/08/02"))
i tried subsituting the sumproduct function and had no luck.
the other thing i'm trying to do(separate from above)
is try to automatically insert todays date(i don't want it to change to tomorrow, tomorrow when i open it) in column g when i type a name in column f.