just drag by the fill handle(i.e right bottom of the cell when cursor
becomes +)


Ron Rosenfeld wrote in message
...
On Sat, 05 Mar 2005 18:23:37 GMT, "Malcolm Austin"
wrote:

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


You did specify a function in B1:


=CHOOSE(MATCH(A1,{"Monday";"Tuesday";"Wednesday";" Thursday";"Friday";"Saturd
ay";"Sunday"},0),
"Tuesday","Wednesday","Thursday","Friday","Saturda y","Sunday","Monday")

--ron