dget or dsum? that is the question

J

justaguyfromky

I want to add a reminder line to my excel workpage. I have a list of dates
that I have certain appointments, also I have a countdown of the number of
days until that appointment. All of this data is already in a table. What I
need it to do is to count the number of appointments I have in the next 7
days. When using the dget or the dsum, I get an error #VALUE

Database: SST (name of the range the database is in)
Field: 3
Criteria: <7

In the criteria line, it wants text, I dont understand why it wont take a
number when a number is what I am looking for.

Any help would be appreciated
 
P

pinmaster

Hi
I'm not an expert but mayby something like this array formula:
=SUM(IF(A1:A16<=TODAY()+6,1,0))-SUM(IF(A1:A16<TODAY(),1,0))
entered with SHIFT+CTRL+ENTER

A1:A16 would be your date column, change to suit your data.

HTH
JG
 

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

Countdown macro - display settings 2
Autonumber field in Excel that behaves the same as Access 0
dget or dsum, that is the question 2
Using lookup functions for Order Sheet 1
Custom Number sequences 0
Outlook calendar list 0
Page numbering with Merged Document and IF statements 1
Dsum and Dmax with structured references 1

Top