Need Date formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What kind of formula would I need in the date field of a query to pull the
next 5 days of orders, including today?
Thanks
Ron
 
What kind of formula would I need in the date field of a query to pull the
next 5 days of orders, including today?
Thanks
Ron
Click to expand...

5 days including today?

Between Date() and Date() + 4

If you meant today and 5 days after today
Between Date() and Date() + 5
 
fredg said:
5 days including today?

Between Date() and Date() + 4

If you meant today and 5 days after today
Between Date() and Date() + 5
Click to expand...

Note, too, that if your Date field also includes Time (because you used Now
rather than Date to populate them), you'll need to add one more than Fred
indicated.
 
Thanks fredg and Doug
It works great.
I wasn't using Now in my in my date query.
Ron
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Formula - Count Dates from another Sheet 8
Excel How to get the number of days an item was opened from the today's date. 14
Excel Dragging countif formula with changing criteria 3
Error on Query with DateSerial() 0
Excel DateDif - why does 2007 seem different? 3
Excel Date Count 2
Using IF formula with dates 0
Workday Formula to include date 0

Back
Top