Replace:

=IF(J3<TODAY(),J3+ROW()/10^10,"")

with:

=IF(DATE(YEAR(J3),MONTH(J3),1)<TODAY(),J3+ROW()/10^10,"")

Copy down the col

The above will return what you want
--
Rgds
Max
xl 97
---
Please respond in thread
xdemechanik <atyahoo<dotcom
----
"Markitos" wrote in message
...
HEllo, i was wondering if their is a way to get dates that will expire
within
the current month. the format Im using now is
=IF(J3<TODAY(),J3+ROW()/10^10,"") which is for today or past. but I would
like the formula to grab dates that are going to expire within this month,
or
have already expirexed. Ive played around w/it alittle but the formulas
have
errors. Thanks for your help - markitos