Formula Help - Days since last event

[jrsomerville]

Hi - I was hoping somebody could help me out with an excel formula. I'm in operations at a landscaping company, and I'd like a better way to keep track of how many days it's been since the property was last serviced. Below is an example of the spreadsheet I have. Let's say today's hypothetical date is 4/17/19. I would like the "days since last visit" column to auto-populate "1 day" for Target, "0 days" for Walmart, "5 days" for Kmart, "3 days" for Petco, and "4 days" for Trader Joes. The dates continue through the end of the season which is 10/31/19 so any time I enter an X on a more current date, I would like it to know to change to "days since last visit" column. Thanks in advance for any help!


[TABLE="width: 500"]
<tbody>[TR]
[TD]Site[/TD]
[TD]Days Since Last Visit[/TD]
[TD]4/1/19[/TD]
[TD]4/2/19[/TD]
[TD]4/3/19[/TD]
[TD]4/4/19[/TD]
[TD]4/5/19[/TD]
[TD]4/6/19[/TD]
[TD]4/7/19[/TD]
[TD]4/8/19[/TD]
[TD]4/9/19[/TD]
[TD]4/10/19[/TD]
[TD]4/11/19[/TD]
[TD]4/12/19[/TD]
[TD]4/13/19[/TD]
[TD]4/14/19[/TD]
[TD]4/15/19[/TD]
[TD]4/16/19[/TD]
[TD]4/17/19[/TD]
[TD]4/18/19[/TD]
[/TR]
[TR]
[TD]Target[/TD]
[TD][/TD]
[TD]x[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]x[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]x[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Walmart[/TD]
[TD][/TD]
[TD][/TD]
[TD]x[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]x[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]x[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Kmart[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]x[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]x[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Petco[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]x[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]x[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]x[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Trader Joes[/TD]
[TD][/TD]
[TD]x[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]x[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]x[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[DanteAmor]

You're welcome & thanks for the feedback.