M
Mark
Sorry, began posting earlier and hit send by mistake!
I have a spreadhsheet that I enter orders onto with the requested delivery
date and order volume.
e.g A1=April 1st, B1=10
A2=April 3rd, B2=15
A3=April2nd, B3=10 etc etc etc
Thing is, the dates dont run consecutively, they are all over the place.
But what I want is a formula that will pick out the dates from 1st month up
to Today +1 (So for today it would search up to 16th April) and add up the
order volume up to that date, I dont want it to pick out any future dates and
add them in, and it needs to be real time eg next morning when I come in the
date resets to "today + 1"
Any thoughts?
I have a spreadhsheet that I enter orders onto with the requested delivery
date and order volume.
e.g A1=April 1st, B1=10
A2=April 3rd, B2=15
A3=April2nd, B3=10 etc etc etc
Thing is, the dates dont run consecutively, they are all over the place.
But what I want is a formula that will pick out the dates from 1st month up
to Today +1 (So for today it would search up to 16th April) and add up the
order volume up to that date, I dont want it to pick out any future dates and
add them in, and it needs to be real time eg next morning when I come in the
date resets to "today + 1"
Any thoughts?