Re: AW 5.1 Question

[Hugh Hood <hughhood@earthlink.net>]

Fellas,

AppleWorks 5.1 eats this stuff up. Not only can you do this with a dot
command macro, you can do it in the spreadsheet using just the @mod and
@choose commands.

AppleWorks 5.1 begins its internal numerical date clock on January 1, 1904,
with a designation of '0'. This day in history happened to be a Friday.

Today is August 5, 2009, a Wednesday, which AppleWorks internally designates
as the number '38568'.

So, just put this formula in a spreadsheet cell to give you the named day:

   @CHOOSE(@MOD(A1,7)+1,"Fri","Sat","Sun","Mon","Tue","Wed","Thu")

'A1' is a reference to your date cell. Normally you'll have this formatted
in your preferred date setting, rather than as just the internal numerical
designation.

This should work until weeks are something other than 7 days long.

Hugh...



in article boucher1-A4F67D.07404804082009@news-wc.giganews.com, Robert
Boucher at boucher1@alumni.texas.net wrote on 8/4/09 7:40 AM:

> Is there a way, formula wise, to get a named day from a date in
> Appleworks 5.1, i.e., Aug 4, 2009 is Tue?