Well, I don't know what happened to my previous post it seems to have got
all
bunched up some how but here is a re-post that is more readable:


Peo,

=DATE(YEAR($A$1),MONTH($A$1),1+7*ROWS($A$1:A1))-4

seems to work just as well as

=DATE(YEAR($A$1),MONTH($A$1),1+7*ROWS($A$1:A1))-WEEKDAY(DATE(YEAR($A$1),MON*TH($A$1),8-5))

(well,up to January 5 2096 anyway when both formulas fail with #NUM!)

May I ask if you have a particular reason for
usingWEEKDAY(DATE(YEAR($A$1),MON*TH($A$1),8-5))I was thinking about
something like when you advised Dave Peterson the otherday about using
ROWS() rather than ROW()

--
Regards


Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


"