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";"Saturday";"Sunday"},0),
"Tuesday","Wednesday","Thursday","Friday","Saturda y","Sunday","Monday")
--ron
|