# Date calculation with Zero *help desperately needed*

#### christat13

##### New Member
Hello,

Second time around trying to post this so if I've missed a detail please let me know.

I was trying to use a max/min function to create a tiered if statement but am not having any luck. I'm open to any ideas and suggestions

I am trying to determine whether inventory has been added, sold or relisted based on dates. Some of the cells have zero in them.
Scenarios:

1. No change as all of the dates are the same across the board i.e. ref #1, 8
2. Inventory is sold as there are dates it was listed and then a zero i.e. ref #8, 80
3. Inventory is sold and then relisted as in Ref #64, 87
4. Inventory is added as in Ref #7, 101

 A B C D E F G H 1 Ref 20160801 20160718 20160701 20160615 20160601 20160517 20160401 2 1 2004-08-06 2004-08-06 2004-08-06 2004-08-06 2004-08-06 2004-08-06 2004-08-06 3 8 - 2007-03-18 2007-03-18 2007-03-18 2007-03-18 2007-03-18 2007-03-18 4 64 - - 2016-05-25 2016-05-25 2016-05-25 - 2014-09-04 5 80 - - - 2016-02-13 2016-02-13 2016-02-13 2016-02-13 6 87 2016-05-06 2016-05-06 2016-05-06 2016-05-06 2016-05-06 - 2013-09-18 7 91 2016-07-11 2016-07-11 - - - - - 8 96 2006-01-20 2006-01-20 2006-01-20 2006-01-20 2006-01-20 2006-01-20 2006-01-20 9 101 2016-07-02 2016-07-02 - - - - -

<tbody>
</tbody>

Thank-you for your time, assistance and brilliant ideas!

### Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

#### oldbrewer

##### Board Regular
what are the dates in the very top row

the dates are split on 2 rows or is the 06 in ref 1 something else

give us one row and explain how inventory levels change

for me it is very unclear at the moment

#### christat13

##### New Member
Hi the dates at the top row are the report dates i.e. newest report is in Column B, followed by Column C...

Dates are only split in the rows due to the width of the table but not in reality

#### christat13

##### New Member

Row #4, ref #64: Inventory was listed on 2014-09-04 and was sold (you can see the zero in the 20160517) and then relisted on 2016-05-25 (as shown on the 20160601 inventory report) and then later resold as it is not on the 20160718 inventory.

Second example row 7, item #91 - all zeros from the inventory reports until 20160708 followed by a date in 20160718 reflecting that inventory was added

finally, example row 3, item #8 - all dates from inventory reports to 20160718 followed by a zero on 20160801 reflecting that it was sold.

Hope that makes it clearer but if not, please let me know and I'll try to add clarification.

#### christat13

##### New Member
Hi,
The issue has been resolved. No reply necessary!
Thanks!

Replies
17
Views
119
Replies
4
Views
51
Replies
3
Views
57
Replies
3
Views
75
Replies
2
Views
27