=--((B1-A1)>=3)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Tammy724882" <Tammy724882.1qfiaa_1118437501.6189@excelforum-nospam.com>
wrote in message
news:Tammy724882.1qfiaa_1118437501.6189@excelforum-nospam.com...
>
> How do I create an IF statement to calculate the following:
>
> Between a series of dates, IF there is a 3 day or more lapse, I want to
> count 1. IF there is less than 3 days, do not count anything
>
> Thanks,
>
> Tammy
>
>
> --
> Tammy724882
> ------------------------------------------------------------------------
> Tammy724882's Profile:
http://www.excelforum.com/member.php...o&userid=24206
> View this thread: http://www.excelforum.com/showthread...hreadid=378204
>