Hi Max

I hadn't seen Bernie's posting.
Cheating..? No, just bending to fit the OP's requirements.
Knowing that neither you nor Bernie could solve it directly makes me feel a
whole heap better somehow!!!!

Thanks for the response.

Regards

Roger Govier


Max wrote:
.. Perhaps you can see the way


No, I'm afraid not <g .. , but I did try-out a cheat
(reading Bernie's closing lines in: http://tinyurl.com/dvskz )
which seems to work ok in Sheet2 in the attached revised file:
WorksheetCalendar_2.xls
re- links at either:

http://cjoint.com/?jCk6l8Wz3z
http://www.savefile.com/files/2959578

Sheet2 has the same array formula as in Sheet1,
but with a cheat attempt <g to show calendar starting with Monday

An additional col I is created to link to the hidden col B,
with a "pull up" of numbers into col I

Placed in I4:
=IF($B$4<"",OFFSET($B$4,ROWS($A$1:A1)-1,),OFFSET($B$4,ROWS($A$1:A1),))

I4 is copied down to I8
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--