How to get last Wednesday of any given month by user

[Ratan Bhushan]

Hi Team

How can I get the last wednesday of any month given by user.

If user enters April or may then I need the date of last wednesday of the same month.

Please help/.

 

[NARAYANK991]

Hi Ratan ,

You have not replied to the answer posted for your earlier thread ; nor to the question posted by Prasad. Can you do so ?

Narayan

 

[kchiba]

Hi Ratan,

Hope the attached helps. I have used a helper column, but you can build the formula without it

kanti

 

[NARAYANK991]

Hi Ratan ,

Earlier you have asked a similar question regarding the Fridays in a month , here :

http://chandoo.org/forum/threads/weekend-date-require-dynamically.20681/

Now , you are asking regarding Wednesdays. If you have checked the file I uploaded there , it is a simple matter to change the check for WEEKDAY = 6 to WEEKDAY = 4.

Narayan

 

[Ratan Bhushan]

Hi Ratan,

Hope the attached helps. I have used a helper column, but you can build the formula without it

kanti

It was awesome.. Thanks a ton. It helped in my project..

 

[Ratan Bhushan]

Hi Ratan ,

Earlier you have asked a similar question regarding the Fridays in a month , here :

http://chandoo.org/forum/threads/weekend-date-require-dynamically.20681/

Now , you are asking regarding Wednesdays. If you have checked the file I uploaded there , it is a simple matter to change the check for WEEKDAY = 6 to WEEKDAY = 4.

Narayan

SIr.... I used that file but couldnt mold the formula i really tried from the same file u have provided me with.. Thanks for your help sir thanks lot...