To answer your first question, you could use a helper column: if your dates
are in Column A, starting in A2, in B2 you could enter =Month(A2) and format
as general. You could then filter on the month you want in Column B and then
hide the column.

I'm not sure what you're looking for in the second question.
--
Sincerely, Michael Colvin


"liamsdad" wrote:


I have a single colum of dates that I would like to format somehow that
show only dates of the current month. I send my spreadsheet to my
customer quarterly and would like it to roll the date to the next
applicable month with a today or now formula if possible.


--
liamsdad
------------------------------------------------------------------------
liamsdad's Profile: http://www.excelforum.com/member.php...o&userid=35388
View this thread: http://www.excelforum.com/showthread...hreadid=552823