Thread
:
Find date of first Monday of each month
View Single Post
#
8
Posted to microsoft.public.excel.misc
Bernd P
external usenet poster
Posts: 806
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
Reply With Quote
Bernd P
View Public Profile
Find all posts by Bernd P