View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
barry houdini[_15_] barry houdini[_15_] is offline
external usenet poster
 
Posts: 1
Default Calculate the first monday of a month in the future or in the past


If you want a series of first Mondays then you can just add the
requisite number of days to your initial calculation, e.g. if you use
Biff's formula to get the first Monday of this month in B2 then you can
use this formula in C2 copied down to get the first Monday of each
subsequent month.

=B2+28+(DAY(B2+28)7)*7


--
barry houdini
------------------------------------------------------------------------
barry houdini's Profile: http://www.thecodecage.com/forumz/member.php?userid=72
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=120021