View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
Bernd P Bernd P is offline
external usenet poster
 
Posts: 806
Default Find date of first Monday of each month

Hello,

Select 12 vertical cells and array-enter (enter with CTRL + SHIFT +
ENTER):
=7+DATE(2008,ROW(INDIRECT("1:12")),1)-
MOD(DATE(2008,ROW(INDIRECT("1:12")),1)-2,7)

Regards,
Bernd