#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 16
Default Date match problem

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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Match date problem Micos3 Excel Discussion (Misc queries) 3 April 23rd 07 12:42 AM
Match Problem Micos3 Excel Discussion (Misc queries) 0 April 22nd 07 01:56 AM
Lookup/Match Problem [email protected] Excel Worksheet Functions 4 March 28th 07 03:03 AM
How can I match a calculated date to closest date from a list? David P Excel Worksheet Functions 2 January 22nd 07 12:05 PM
match problem bill gras Excel Worksheet Functions 8 December 30th 05 05:48 AM


All times are GMT +1. The time now is 05:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"