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.