Formula to find date of every Monday in the current month

[Junarkar]

Hi

I have some formula which needs date of Mondays of the current month. As of now I'm using an array in which I manually feed the dates. Is there a way to automate this using some formula.

Thanks a lot

 

[salim hasan]

Try this file

 

[Peter Bartholomew]

Somewhat overkill but the attached utterly ignores the normal practices of end-user-computing to produce its solution. It is based upon the volatile function TODAY() so it only applies to the current month and will change as the month changes.

 

[Junarkar]

Try this file

Thanks a lot Salim. Still I couldn't figure out how the formula works but really solved my issue. You are brilliant

 

[Junarkar]

Somewhat overkill but the attached utterly ignores the normal practices of end-user-computing to produce its solution. It is based upon the volatile function TODAY() so it only applies to the current month and will change as the month changes.

Thanks a tone Peter..!!! Special thanks for your explanation.... really appreciate that you made time to explain it. still pretty hard for me to digest....
Those Arrays are really something to crack my head..
Using Today() function is not a bad idea though.