Between Dates
Hi All,
I have dates in A2, B2 & C2. I need a formula in D2 which yeilds a number one if C2 falls between A2 & B2 Can anyone help me. Thanks very much Tom Snyder |
Between Dates
Hi Tom
=IF(AND(C2=A2,C2<=B2),1,"") -- Regards Roger Govier "lehigh46" wrote in message ... Hi All, I have dates in A2, B2 & C2. I need a formula in D2 which yeilds a number one if C2 falls between A2 & B2 Can anyone help me. Thanks very much Tom Snyder |
Between Dates
Tom, Assuming A2 is less than B2, =IF(AND(C2A2,C2<B2),1,"") HTH Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=507786 |
All times are GMT +1. The time now is 11:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com