Posted to microsoft.public.excel.misc

Micos3

external usenet poster

Posts: 16

Match date problem

Hi!
I have a table with some kind of calendar, i.e.
Jan - 1 2 3 4 5 6 7 8 F F F F F F 15 16 17 18 ... 2007
Feb - 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17... 2007
Mar - ....
Apr - ....
May - 1 2 3 4 M M M M 9 10 11 12 13... 2007

I want to have a cell in wich ill have a warning like "near Vacancies" that
appears on 5 days before vacancies (M). Can someone help me?
Thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 Problem	Micos3	Excel Discussion (Misc queries)	0	April 22nd 07 01:56 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 function problem	LACA	Excel Discussion (Misc queries)	10	May 22nd 06 01:39 AM
match problem	bill gras	Excel Worksheet Functions	8	December 30th 05 05:48 AM
problem with =isnumber(match(right(...	Luke	Excel Worksheet Functions	17	September 25th 05 01:01 AM

All times are GMT +1. The time now is 10:07 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us