MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Using Months in Excel


Posted by Johnnie on September 11, 2001 9:29 AM

Hi, Can somebody please help me!!

I need to show details for a given month only. For example:

If the month is September then I need to show the amount of data within the September column only. I am trying to use Today() as this needs to be updated automatically. Any ideas would be greatfully appreciated. Cheers ;o)

E.g.

Aug/Sep/Oct Monthly Total
2 3 0 3
1 0 0 0
0 4 0 4


Posted by IML on September 11, 2001 10:46 AM


Try:
=SUM((MONTH($A$1:$C$1)=MONTH(NOW()))*(A2:C2))
and copying down. You must hit enter while control and shift are depressed. Also, A1:C1 must be date formats.

Posted by Johnnie on September 11, 2001 11:17 AM

Thnx for the reply IML. Would it be possible for me to email you my spreadsheet? which I will detail fully and see if you can see my dilema. I am new at spreadsheets and would appreciate any help possible :) again thnx for replying

Posted by IML on September 11, 2001 1:04 PM

Unfortunately, I can't receive files. To clarify a little further, I assumed your dates were in A1:C1. You could type in a date like 9/1/01 and format it to mmmm so "september" would appear
The formula I gave you would be typed under your monthly total column (D2) in my example. Then you could simple copy D2 down as far as you need.
Sorry I couldn't help more.

Posted by Aladin Akyurek on September 11, 2001 1:11 PM

Ian & Johnnie,

Even after Ian's interpretation, it's not clear to me what is wanted.

Maybe Johnnie can post 5 rows of data (from his worksheet) with the expected results.

Aladin

============ Unfortunately, I can't receive files. To clarify a little further, I assumed your dates were in A1:C1. You could type in a date like 9/1/01 and format it to mmmm so "september" would appear

Posted by johnnie on September 12, 2001 4:42 AM

Thnx for all your help so far. I have uploaded my spreadsheet to my homepage if you would'nt mind taking a look for me. Pict takes a while to download. it's at:

(link no longer valid)

Once again I appreciate your help :) Ian & Johnnie, Even after Ian's interpretation, it's not clear to me what is wanted. Maybe Johnnie can post 5 rows of data (from his worksheet) with the expected results. Aladin ============ : Unfortunately, I can't receive files. To clarify a little further, I assumed your dates were in A1:C1. You could type in a date like 9/1/01 and format it to mmmm so "september" would appear


Posted by Aladin Akyurek on September 12, 2001 5:34 AM

Johnnie,

In S7 enter: =INDEX(C7:Q7,MATCH(TEXT(TODAY(),"mmm"),$C$4:$Q$4,0))

Copy down this formula as far as needed.

Aladin

============= Thnx for all your help so far. I have uploaded my spreadsheet to my homepage if you would'nt mind taking a look for me. Pict takes a while to download. it's at: Once again I appreciate your help :) : Ian & Johnnie, : Even after Ian's interpretation, it's not clear to me what is wanted. : Maybe Johnnie can post 5 rows of data (from his worksheet) with the expected results. : Aladin : ============

Posted by Johnnie on September 12, 2001 5:56 AM

Niceone m8 Worked a treat. I am forever in your debt. THANK YOU VERY MUCH!!! :D Johnnie, In S7 enter: =INDEX(C7:Q7,MATCH(TEXT(TODAY(),"mmm"),$C$4:$Q$4,0)) Copy down this formula as far as needed. Aladin ============= : Thnx for all your help so far. I have uploaded my spreadsheet to my homepage if you would'nt mind taking a look for me. Pict takes a while to download. it's at