To get all dates for specific Day

[brajpalshishodia]

Hello Champs,

We all know that from a date, many information could be extracted e.g. Month, year, day, weekday, weeknumber.

However my requirement is little tricky. Actually I need a macro which can get all the dates in a month for specific day, e.g. If I say "Sunday" then all dates for Sunday should be captured in excel from a specific month.

Kindly let me know if there is any way to accomplish this.

[LokeshKumar]

Hey BrajPal,

Upload the sample workbook......

[brajpalshishodia]

Hello Lokesh,

I don't know why but after several attempts, I'm not able to upload the sample workbook, however the requirement is simple.

I have Month in one Cell "Jan'13", now all dates are required in other column on which "Saturday" fall, like

1/5/2013
1/12/2013
1/19/2013
1/26/2013

Hope it's little clear now.

Appreciate you help on this.

[LokeshKumar]

ok send me on email [email protected]

[LokeshKumar]

Hi,

This is the formula

Please Login or Register  to view this content.

[LokeshKumar]

If your question is resolved, mark it SOLVED using the thread tools. Click on the star if you think some-1 helped you.

[JOHN H. DAVIS]

Maybe?

Please Login or Register  to view this content.

[nickhunt]

John,
does this work for the current month or any month?

[JOHN H. DAVIS]

John,
does this work for the current month or any month?

It's based on the date placed in cell A2. What ever month is in that cell.

[nickhunt]

ok, thanks

[LokeshKumar]

@nickhhunt
There was some issue in uploading the attachment......
Here is attachment for your reference......Date Conversion Tool_v1.xlsx

[nickhunt]

John,
If I put April 2015 in A2 I get a list in Column B in format 013/2015, 014/2015, 015/2015 etc. Any ideas?

[JOHN H. DAVIS]

John,
If I put April 2015 in A2 I get a list in Column B in format 013/2015, 014/2015, 015/2015 etc. Any ideas?

You need to put a full date. 04/01/2015. Also, I think you should comply with Forum Rules and start a thread of your own, and maybe reference this one.