View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Date match problem

You haven't said what you want to do if you match the date, but assuming
that you want to highlight that date with cell formatting, try formatting
cell B2 by
Format/ Conditional Formatting/ Formula is:
=TODAY()=DATE($AK2,MONTH($A2),B2), then choose an appropriate format (and
copy the format to the other cells).

[I'm assuming that column A are not text entries for month names, but dates
formatted as mmm or something similar to show the month name; that makes it
easier.]
--
David Biddulph

"Micos3" wrote in message
...
I have a calendar in wich i need that it recoginizes the day where it is
today, to do what i want.
Tha calendar has Month Col A, Days in other columns and in Col AK has the
year. How can i do this?