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

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

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,114,249
Messages
5,546,746
Members
410,757
Latest member
jonni
Top