Try this formula:

=SUMPRODUCT(--(Sales=--"07/01/2008"),--(Sales<=--"07/31/2008"),--(Ship--"07/31/2008"))

where Sales is your SalesDate range, and Ship is your ShipDate range.
--
John C


"KMC" wrote:

SaleDate EstShipDate
7/2/08 7/18/08
7/12/08 8/5/08
7/30/08 9/4/08
8/3/08 8/25/08

How do I combine the functions below so I can see how many orders were
placed in July but will ship after July? I'm looking for a result of 2.

=COUNTIF(saledate,"=07/01/2008")-COUNTIF(saledate,"07/31/2008")
=COUNTIF(EstShipDate,"07/31/2008")

THANKS!!!