try
=if(and(a1>=b1,a1<c1),1,"")
Don Guillett
SalesAid Software
dguille...@gmail.com
-----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
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!
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
