try
=if(and(a1>=b1,a1-Original Message-
From: RockyFontane
Sent: Monday, October 17, 2011 10:08 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Quick Date Count Question
I'm trying to determine if a specific date falls between a start and
end date. For example:
A1: 9/7/2011
Hi
Try this
=if(and(a1c1),a1,0)
Thanks and Regards,
Somnath C Pardeshi
Sent from my BlackBerry® Smartphone on Loop Mobile.
-Original Message-
From: RockyFontane
Sender: excel-macros@googlegroups.com
Date: Mon, 17 Oct 2011 08:08:40
To: MS EXCEL AND VBA MACROS
Reply-To: excel-macros@go
Since you have only specified between B1, and C1, and not whether B1 will
always be lesser than C1, here's a generic formula.
=IF(AND(A1>=MIN(B1,C1),A1<=MAX(B1,C1)),1,0)
Regards,
Sam Mathai Chacko
On Mon, Oct 17, 2011 at 8:38 PM, RockyFontane wrote:
> I'm trying to determine if a specific dat
