Current Month

Hi there,

I have to a table as below. Can i always get the All months as the current month number in this instance it would be 3 as this month is september. If i do Month(Today()) it gives me 9 but i want is 3.

All Months
Jul 1
Aug 2
Sep 3
Oct 4
Nov 5
Dec 6
Jan 7
Feb 8
Mar 9
Apr 10
May 11
Jun 12

Any suggestions please.

Thanks

Abhi

Yes, The current month is sep but i have designated it as 3. Can i get 3 beside all months. And for Oct it should be 4 and so on

x-post

http://www.mrexcel.com/forum/showthread.php?t=494106

This formula worked courtsey MrKowz

=MONTH(DATE(YEAR(TODAY()),MONTH(TODAY())-6,DAY(TODAY())))