You can create a date using the Row two name. for example

=DateValue("January 1, 2009")
=DateValue(A2&" 1, "&year(now())


Now you can compare the month in A1 with the month in the above formula

if(month(A1)=DateValue(A2&" 1, "&year(now()),True,false)







"Kay" wrote:

That is correct; I need to sum each column then over ride that one month
which reference to A1
--
KK


"MyVeryOwnSelf" wrote:

I want a formula base on cell A1(start month)
this formula should only be under May in E5

I'm guessing that what you mean by
"base on cell A1"
is
"the month of A1 determines which column cannot go over 1."

Maybe it would help to put this in A5 and extend it to L5:
=IF(MONTH($A$1)=COLUMN(), MIN(A3-A4,1), A3-A4)