Malcolm,

If you have entered a Monday date in cell A1 and formatted to show just the
day by using custom format then =A1+1 will return Tuesday. To format chose
Format menu, Cells..., Number tab, Custom (last option) then type in dddd.

Hope this helps, Rob

"Malcolm Austin" wrote in message
...
I know I'm going to kick myself when I get the reply on this, but...

How do I get a day (Monday) to update to Tuesday with a worksheet
function.

If I have Monday in A1, and want Tuesday in B1, what do I write? A1+1
doesn't seem to
work and I don't see a format just for days?

Please put me out of my misery !!


Malcolm