# Excel - COLUMN Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I was jut receiving help from a spreadsheet expert. He/She was able to create the right formula in cell F2, but now I'd like to figure out how to easily take that formula across column 2 without having to type in date and time criteria for each cell.
Solved by I. W. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 22/05/2017 - 06:10
User 22/05/2017 - 06:11
ok thanks - I'm wondering if the same person is available bc they can still work on it
Excelchat Expert 22/05/2017 - 06:11
Can you please provide me the sheet to work on.
User 22/05/2017 - 06:11
they were getting close to figuring it out
User 22/05/2017 - 06:11
Excelchat Expert 22/05/2017 - 06:12
Hi, I am interacting with you first time. I am taking look at it.
User 22/05/2017 - 06:12
okay but someone else is still working on it
User 22/05/2017 - 06:12
they were close to figuring it out
User 22/05/2017 - 06:12
we just ran out of time, so I need to purchase another session
Excelchat Expert 22/05/2017 - 06:12
At present, all experts are in sessions. I am the only one interacting with you.
User 22/05/2017 - 06:13
ok
Excelchat Expert 22/05/2017 - 06:13
User 22/05/2017 - 06:13
the previous expert was able to put the right formula into cell F2 on the tab titled SF - Fulfillment Manifest
Excelchat Expert 22/05/2017 - 06:13
Ok. I am at that location.
User 22/05/2017 - 06:14
however, I'd now like to copy that formula indefinitely across row 3
Excelchat Expert 22/05/2017 - 06:14
Whether the result is correct as expected?
User 22/05/2017 - 06:14
the criteria is for Monday: ll orders placed between the previous Wednesday at 6:01 am and Monday at 6:00 am
User 22/05/2017 - 06:14
sum the quantity of orders placed
Excelchat Expert 22/05/2017 - 06:14
Ok.
User 22/05/2017 - 06:14
or Wednesday: all orders placed between the previous Monday at 6:01 am and Wednesday at 6:00 am.
User 22/05/2017 - 06:15
the formula is right in F3, but I don't want to have to manual input it across the dates
Excelchat Expert 22/05/2017 - 06:15
I think, the formulas are already avaialble
User 22/05/2017 - 06:15
I'm wondering if there is an easy way to look at it
Excelchat Expert 22/05/2017 - 06:15
Ok. Great.
Excelchat Expert 22/05/2017 - 06:15
I am checking it.
Excelchat Expert 22/05/2017 - 06:17
Ok. I got it.
Excelchat Expert 22/05/2017 - 06:17
I am trying to find a different formula to get as required.
Excelchat Expert 22/05/2017 - 06:20
Ok. Now, i have updated the formulas for F3
Excelchat Expert 22/05/2017 - 06:21
And H3 is same as previous one.
User 22/05/2017 - 06:21
ok
Excelchat Expert 22/05/2017 - 06:22
There should be a different in formulas for F3 and H3. As there is a date range difference.
Excelchat Expert 22/05/2017 - 06:23
It looks like there is no data to calculate for Column O to V
Excelchat Expert 22/05/2017 - 06:24
Otherwise, i have updated the formula
User 22/05/2017 - 06:24
yes that is correct
Excelchat Expert 22/05/2017 - 06:24
The problem is solved :)
User 22/05/2017 - 06:24
so if I add more dates can I drag the formula over
Excelchat Expert 22/05/2017 - 06:24
You can copy the set of 2 formulas (monday + wednesday)
User 22/05/2017 - 06:24
awesome
Excelchat Expert 22/05/2017 - 06:24
As there are gaps between 2 rows.
User 22/05/2017 - 06:25
and I see you've already copied it down
Excelchat Expert 22/05/2017 - 06:25
Yes. I did
Excelchat Expert 22/05/2017 - 06:25
So glad to hear that! Please come back to Excel Chat for any you spreadsheet problems. Also, please have a wonderful day! Thank you!
User 22/05/2017 - 06:25
I'm only going to do Monday and Wednesday in row 1
User 22/05/2017 - 06:25
I'll delete the other dates
User 22/05/2017 - 06:25
will that mess up formula
Excelchat Expert 22/05/2017 - 06:26
Is it 5 days back or 7 days back.
User 22/05/2017 - 06:27
On Monday, the staff Roasts and Fulfills for all orders placed between the previous Wednesday at 6:01 am and Monday at 6:00 am On Wednesday, the staff Roasts and Fulfills for all orders placed between the previous Monday at 6:01 am and Wednesday at 6:00 am.
Excelchat Expert 22/05/2017 - 06:27
Ok. I have updated the formula
Excelchat Expert 22/05/2017 - 06:28
I have used 5 days back.
User 22/05/2017 - 06:28
awesome
User 22/05/2017 - 06:28
s!
User 22/05/2017 - 06:29
thanks!
Excelchat Expert 22/05/2017 - 06:29
You may now close this chat. Please leave a 5-star rating after ending the session:)
User 22/05/2017 - 06:29
will do
Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.