Date problem!
 

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

Date problem!
 

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

Date problem!
 

example:
column G
13-jan-06
20-apr-06
22-jun-06
24-jun-06

I would like the current month "highlighted" other month blanked out or
non visible. With that I only send this randomly so I need for when they
open it be it may, june or whenever the corresponding month is
"highlighted"


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

Date problem!
 

You should be able to do what you want with conditional formatting
(FormatConditional Formatting...)

For example, a date in the current month would use the formula:

=month(today())=month(a1)

--
Regards,
Fred


"liamsdad" wrote in
message ...

example:
column G
13-jan-06
20-apr-06
22-jun-06
24-jun-06

I would like the current month "highlighted" other month blanked out or
non visible. With that I only send this randomly so I need for when they
open it be it may, june or whenever the corresponding month is
"highlighted"


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