fredguitar
New Member
- Joined
- Feb 4, 2012
- Messages
- 3
I want to have a cell that contains a numeric value that's connected somehow to a date. Is there a way to make a cell that contains a value to be "date specific".
Here's what I'm trying to do. I'm making a sheet that is helping me determine inventory quantities at the beginning of each month. Throughout each month, I expect quantities of shipments on certain dates.
Then, I want to apply the following condition to that "date specific" value. If the shipment arrives before, "this date", then it goes in "this column". Or, if the shipment arrives on or after, "this date", then it goes in "this column".
In addition, there may be more than one shipment, so I'd have to add those too!
[TABLE="width: 500"]
<tbody>[TR]
[TD]Shipment 1[/TD]
[TD]Shipment 2[/TD]
[TD]Shipment 3[/TD]
[TD]Total Inventory on Nov. 1[/TD]
[TD]Total Inventory on Dec. 1[/TD]
[/TR]
[TR]
[TD]Value with Date.
Conditional.[/TD]
[TD]Value with Date
Conditional.[/TD]
[TD]Value with Date
Conditional.[/TD]
[TD]Sums of All shipments Before November 1st[/TD]
[TD]Sums of All Shipments On of After November 1st[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Here's what I'm trying to do. I'm making a sheet that is helping me determine inventory quantities at the beginning of each month. Throughout each month, I expect quantities of shipments on certain dates.
Then, I want to apply the following condition to that "date specific" value. If the shipment arrives before, "this date", then it goes in "this column". Or, if the shipment arrives on or after, "this date", then it goes in "this column".
In addition, there may be more than one shipment, so I'd have to add those too!
[TABLE="width: 500"]
<tbody>[TR]
[TD]Shipment 1[/TD]
[TD]Shipment 2[/TD]
[TD]Shipment 3[/TD]
[TD]Total Inventory on Nov. 1[/TD]
[TD]Total Inventory on Dec. 1[/TD]
[/TR]
[TR]
[TD]Value with Date.
Conditional.[/TD]
[TD]Value with Date
Conditional.[/TD]
[TD]Value with Date
Conditional.[/TD]
[TD]Sums of All shipments Before November 1st[/TD]
[TD]Sums of All Shipments On of After November 1st[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]