Help with an IF statment

[Tammy724882]

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

[Jordon]

=IF(B1-A1>=3,1,"")

"Tammy724882" wrote
>
> 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

[spencerchicken]

dont fully understand what your trying to do but here goes..
make sure the dates are numbers not text (format the number) this will
allow you to treat the date as a value.
Do an if statement of comparing one date to another as a number
eg,
cell 1a 1st jan 2005
cell 2a 3jan 2005
=IF(A2-A1<3,0,1)

[Ken Wright]

=--((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
>