Hi Ian,

Look he

http://www.cpearson.com/excel/DateTi...tm#LastWeekday

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Ian R" wrote in message ...
| Hi
|
| I'd like to find out the date of the first Monday of every month for the
| current year. Ideally I'd like to display this in a list e.g. A1 to A12
|
| I'm sure this can be calculated in Excel but I'm not sure what formula would
| do this.
|
| Any pointers would be gratefully received.
|
| Many thanks
|
| Ian
|
|