Month only reference in formula

austin350s10

Active Member
Joined
Jul 30, 2010
Messages
321
I have a table I am working on that is broken down into the months of the year. Each row of the table need to be populated only if the system month is equal to the month on the table.

The only formulas I can find just reference specific dates such as the full date. i.e. 09/01/2010

Here is a very persocode example of the formula I am looking for:

IF(AND(system date(month)="09",(table month="09")),run formula,"")

How can I get this formula to work correctly??
 

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

Jonmo1

MrExcel MVP
Joined
Oct 12, 2006
Messages
44,061
Try using TODAY

=IF(MONTH(TODAY())=MONTH(celldate),run formula,"")
 

austin350s10

Active Member
Joined
Jul 30, 2010
Messages
321
You are sooooo close I think. I think your code refers to a spicific date still...maybe :-\ The area in concern for me is the (celldate) part of your formula. My (celldate) is just the month i.e. 01, 02, 03...

Will it work with just a month value or perhaps the month as text i.e. january, febuary, ....??

=IF(MONTH(TODAY())=MONTH(celldate),run formula,"")
 

austin350s10

Active Member
Joined
Jul 30, 2010
Messages
321
Sorry I wanted to change the formula a little to see if this is possible....

=IF(MONTH(TODAY())=MONTH("january"),run formula,"")


Thankssssss
 

Jonmo1

MrExcel MVP
Joined
Oct 12, 2006
Messages
44,061
Try

=IF(MONTH(TODAY())=9,run formula,"")

9 = sept
10 = october
1 = january
etc..
 

austin350s10

Active Member
Joined
Jul 30, 2010
Messages
321
Dude you Fing rock....this just condensed a paragraph long formula I had earlier to one line. YESSSS!!!!!
 

Watch MrExcel Video

Forum statistics

Threads
1,109,451
Messages
5,528,832
Members
409,839
Latest member
akashsadhu
Top