Hi Morocco,

Look here and a little bit above and below:

http://www.cpearson.com/excel/DateTimeWS.htm#NthDoWYear

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Morocco Mole" wrote in message
...
Hello.

If I have a date in cell a1, what would be the formula to calculate the
first Monday of the next month (+1 month), and then the first Monday of
next
month after that (+2 months)?

Also, would this formula be able to be used to calculate first Monday of
the
current and the past months? (I assume you can just change a number in
the
formula).

--
Thanks,

Morocco Mole