Date problem!

L

liamsdad

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.
 
M

Michael

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.
 
L

liamsdad

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"
 
F

Fred Smith

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

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

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