How to identify the last thursday of any month

[thisisrahul]

Hi,
is there a way in excel by which i can come to know about the last thursday of a month.
i am using excel 2007.


________
Rahul

 

[bradley7]

set TO 1st of the follow month.
WHILE SUBTractIng 1 from the date, check the DAY function , I think 0 = Sunday so check for 4

 

[Aladin Akyurek]

Hi,
is there a way in excel by which i can come to know about the last thursday of a month.
i am using excel 2007.

See:

http://www.mrexcel.com/forum/showthread.php?t=455805

If any trouble with that, a long-hand expensive solution would be:

=LOOKUP(9.99999999999999E+307,
   1/(TEXT(ROW(INDIRECT(A1-DAY(A1)+1&":"&EOMONTH(A1,0))),"ddd")="thu"),
   ROW(INDIRECT(A1-DAY(A1)+1&":"&EOMONTH(A1,0))))

 

[thisisrahul]

thanks all,
i want to capture the same data for thursday, though i tried some permutation - combation but all in vain.

can you help me with this ?

 

[Aladin Akyurek]

thanks all,
i want to capture the same data for thursday, though i tried some permutation - combation but all in vain.

can you help me with this ?

How do yu mean? Did you also try the longer version? Note that you need to have an input date in A1 for the formula to work...

 

[Armando Montes]

From Barry Houdini:
= EOMONTH(A1,0)-WEEKDAY(EOMONTH(A1,0)+3)+1
http://www.mrexcel.com/forum/showthread.php?t=212310

 

[kraestumpf]

Barry Houdini, you are my favorite person on Mr Excel... always the simplest and easy to understand solutions.

Thank you... you have made my work so much easier with this and many other solutions.

From Barry Houdini:
= EOMONTH(A1,0)-WEEKDAY(EOMONTH(A1,0)+3)+1
Date of last Friday in a month