Hi Winston
I have translated Jim's code into a worksheet function. Enter in the
relevant cell:
=IF(WEEKDAY(TODAY())<6,TODAY()-WEEKDAY(TODAY())-1,TODAY())
Note: this is a volatile function, it will be recalculated everytime you
open, close, save or change the file so that calculation is triggered.
Hope this helps
Rowan
Winston wrote:
Hi Jim
Thanks very much for reply, but what does all this mean.
I am a new uses seems that my problem will not be sorted.
Thanks very much anyway
Winston