formulas

  • Thread starter Thread starter Kay
  • Start date Start date
K

Kay

Cell A1 have May 5, 2006(start date)
cell A2:L2 have month from January to december
In cell A3:L3 and A4:L4 I have numbers under each months
in cell A5:L5 I have the fomula =A3-A4 I do this across to L3-L4
The only problem I need a formula to Make E5 which is under the month of may
1 or less than 1(it cannot go over 1) the other cells can be flexible
This formula should be base one cell A1 Start date.
 
I want a formula base on cell A1(start month)
this formula should only be under May in E5
Click to expand...

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)
 
That is correct; I need to sum each column then over ride that one month
which reference to A1
 
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)
 
Back
Top