Enter zero in Col B where date in Col A is 40+ days from last row with zero in Col B

All,

I have an ordered range of dates in cells A1-A11:

9/6/2017
9/19/2017
10/3/2017
10/17/2017
10/25/2017
11/14/2017
11/28/2017
12/14/2017
3/1/2018
6/19/2018
7/3/2018
7/17/2018

In column B, I want to "mark" every row that is 40 or more days from the last "marked" row. Note that the first date (first row) should always be "marked" in cell B1. The mark that I prefer is to enter 0 (zero) in the corresponding cell in column B. All other cells in column B should remain blank. I'm looking for one formula that I can copy down column B that will provide the desired result (see below):


9/6/2017 0
9/19/2017
10/3/2017
10/17/2017 0
10/25/2017
11/14/2017
11/28/2017 0
12/14/2017
3/1/2018 0
6/19/2018 0
7/3/2018
7/17/2018

I look forward to your answers! Thanks so much!

JayUSA

Use a formula and the the DAYS360() function that calculates the number of days between two dates.
Depending on which date you place first it's either + or -
Check the Syntax in the Formula itself, just type = DAYS360( and the fx button in the formula bar

You then can make it an IF statement to show something or conditional formatting to mark that cell and not need an extra column

Something like this

Please Login or Register  to view this content.

Or this

Please Login or Register  to view this content.

You'll have to check the syntax and so, but I'm sure you can solve it.

Then just double-click the right bottom corner of that cell and formula gets copied all the way down to the last filled row

	A	B	C
1
2	9/6/2017	0	B2: Input
3	9/19/2017		B3: =IF(INT((A3 - A$2)/40) > INT((A2 - A$2)/40), 0, "")
4	10/3/2017
5	10/17/2017	0
6	10/25/2017
7	11/14/2017
8	11/28/2017	0
9	12/14/2017
10	3/1/2018	0
11	6/19/2018	0
12	7/3/2018
13	7/17/2018

Sorry, I misunderstood your question.
But... you've got the answer.

My guess is , if you look at the parameters you're allowed to pass that a 1 can stand for TRUE of a the actual value 1