# Date Month Syntax

#### walkingfather

##### New Member
What am I doing wrong with this array formula?

{=SUM(B3:B20=MONTH(1))*(C3:C20="income")*(F3:F20+G3:G20)}

The =month(1) i want it to find all enteries in Feb.

Gavin

### Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off
excel stores dates as integers, starting with 1 for 01/01/1900, 2 for 02/01/1900 etc. Today, 5th December 2005 is 38,691

The month of 01/01/1900 is 1.

The syntax for that sort of thing is:

sum((range=condition)*(range=condition)*(range_to_sum))

...notice the brackets.

I understand the syntax for the sum, and i understand how excel stores dates from 1900.

but i just must be stupid on the date condition

sum((range=condition) what is the formula syntax for finding dates between 1/1/06 and 1/31/06 ??...

Do i have to use and if statement?

my dates are stored in the range with this format mm/dd/yyyy

thanks,
gavin

some examples:
Book2
ABCDEF
1DateAmount
21/12/2005121
315/12/2005221
429/12/2005321
512/01/2006421
626/01/2006521
79/02/200669FALSE
823/02/200679
99/03/200689
1023/03/20069FALSE
116/04/200610
1220/04/200611
131/01/200112
Sheet2

Something isn't right with column D.

0=Jan
1=Feb

in the feb dates you have 6+7

Maybe it's the way the dates are arranged?

you have dd/mm/yyyy instead of mm/dd/yyyy

i can't get it to work either way

thanks for the help though i feel i am getting closer every day,

Gavin

0=Jan
1=Feb"

The month number for January is 1, for February 2 etc. There is no month whose number is 0, at leasst not in terms of the excel defaults.

Hey thanks for the info...I used one of your formulas and tweaked it a little bit to fit my sheet...thanks again for all your time and help,

Gavin

Replies
2
Views
193
Replies
5
Views
405
Replies
3
Views
102
Replies
4
Views
846
Replies
5
Views
155

1,196,514
Messages
6,015,643
Members
441,913
Latest member
Lhayden_69

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back