Date match problem

M

Micos3

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?
 
D

David Biddulph

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

Micos3

it is dificult to explain exactly the whole proBlem, i have explain it Better
in a question that i post here But didn't have awnser that had worked.
The post is "Match date problem"
Is a complex proBlem.
Thanks

"David Biddulph" escreveu:
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 said:
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?
Click to expand...
Click to expand...
 
Top