[Linux-disciples] OO and day of the week

[Stephen R Laniel]

OpenOffice has the weekday() function, which will return the
numerical index of the day of the week (Sunday = 0). If I
want to get an actual text weekday ("Monday", etc.), is
there any easier way than writing

=if(weekday(c4)=0;"Sunday";if(weekday(c4)=1;"Monday";if(weekday(c4)=2;"Tuesday";if(weekday(c4)=3;"Wednesday";if(weekday(c4)=4;"Thursday";if(weekday(c4)=5;"Friday";if(weekday(c4)=6;"Saturday";"Sunday")))))))

?

-- 
Stephen R. Laniel
steve at laniels.org
+(617) 308-5571
http://laniels.org/
PGP key: http://laniels.org/slaniel.key
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
Url : http://lists.bostoncoop.net/pipermail/linux-disciples/attachments/20051130/2f3fb309/attachment.pgp