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:
@googlegroups.com
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
B1: 9/28/2011
C1: 11/2/2011
If A1 is between B1 and C1, then return a 1 if not, then return a
zero.
Seems like it
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
I'm trying to determine if a specific date falls between a start and
end date. For example:
A1: 9/7/2011
B1: 9/28/2011
C1: 11/2/2011
If A1 is between B1 and C1, then return a 1 if not, then return a
zero.
Seems like it would be easy, but been scratching my head on this too
long.
Thanks!
--