If Formula with dates

P

Phil

I have a table and I am trying to use a if formulas to return a value. For
example,
Return a value if the date on that row is less or equal to January 31, 2008.
 
T

Thomas [PBD]

Phil,

Is the value you are returning going to be a constant or another cell within
that row, or on another worksheet, etc.
 
P

Phil

Yes!

Basically the folowing is how I want it to work:

I have a sample of the table that I working on as showing below:
Name Date Amount January February ....
Un Nyobe January-08 $56.00
Kwame Krumah June-08 12.00

I would like excel to return amount entered in the "amount column" in a
specific month if the date is within that month. For example, in the month of
January, please entered $56 if the date is anywhere between January 1 thru
31, 2008
 
T

Thomas [PBD]

Phil,

Assuming that Name starts in A1, Date is formatted as a "Date", and your
month columns are Text:

=IF(TEXT($B2,"mmmm")=D$1,$C2,"")

Place this formula into the January column to the right of Amount. Copy and
Paste Special (Formula) into the columns of the months, you should have your
answer. If needed you can replace the "" with 0 to pull a zero value for
that row where the Months do not match.
 
Top