I Don't know if I have made myself clair.

I was able to build the following formula

=IF(E18DATE(2008,4,30),IF(E18<=DATE(2008,5,31),F1 8),"").

The above is close to what I wanted, meaning if the date in E18, column K
is greater than April 04, 2008, if at the same time date in the same row is
also equal or less than May 05, 2008, display the value in F18, otherwise
leave the cell blank.
HOWEVER, THE FORMULA ABOVE IS NOT WORKING AS I WANTED TO. INSTEAD OF
DISPLAYING A BLANK CELL, IT DISPLAYS "FALSE".
--
Phil


"RagDyer" wrote:

Assuming month names in column headers D to O are text, and dates in Column
B are "legal" XL dates, try this in D2:

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

Copy across to Column O (December),
Then copy the range D2:O2 down as far as needed.

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Phil" wrote in message
...
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
--
Phil