i need to be able to capture the average of amounts in column d if column b
is between 1/7/9 and 31/7/9. can it be done?

"Jacob Skaria" wrote:

The below function will return 10 if the month of date in B2 is 7.

=IF(--TEXT(B2,"mm")=7,10,0)

=IF(--TEXT(B2,"mm")=7,"True","False")


If this post helps click Yes
---------------
Jacob Skaria


"mbr" wrote:

what function would i need to do the following:

add amounts in column d if column b is between 01/07/09 and 31/07/09.