=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
=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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks