Tricky Scenario finding days/months/years!

[Rizitsu]

I have tried both your solutions, i return a #VALUE! Error when place
in both scenarios.

Here is the method in which i set up the data.

SMS SME Date Result

Mon 29/12/2003 Sun 25/01/2004 01/03/04 =VLOOKUP((G5),2,2,(E5:F16))
Mon 26/01/2004 Sun 29/02/2004
Mon 01/03/2004 Sun 28/03/2004 =TEXT(G5,E5:F16)
Mon 29/03/2004 Sun 25/04/2004
Mon 26/04/2004 Sun 30/05/2004
Mon 31/05/2004 Sun 27/06/2004
Mon 28/06/2004 Sun 25/07/2004
Mon 26/07/2004 Sun 29/08/2004
Mon 30/08/2004 Sun 26/09/2004
Mon 27/09/2004 Sun 31/10/2004
Mon 01/11/2004 Sun 28/11/2004
Mon 29/11/2004 Sun 26/12/2004


As you can see, my cell reference for the above service dates ar
within the range E5:F16. Cell G5 is the Date i want to check agains
the service dates.

If this is plausable, please help.

Thanks.

PSA

+-------------------------------------------------------------------
|Filename: Test.zip
|Download: http://www.excelforum.com/attachment.php?postid=2788
+-------------------------------------------------------------------

 

[Lynxbci3]

have a look at thi

 

[Lynxbci3]

i will attach this tim

+-------------------------------------------------------------------
|Filename: Test2.zip
|Download: http://www.excelforum.com/attachment.php?postid=2789
+-------------------------------------------------------------------

 

[Guest]

Hi
if these are real date/time values
TEXT(G5,"MMMM")
should do