Re: AW 5.1 Question

[Robert Boucher <boucher1@alumni.texas.net>]

In article <C69FC1CB.3099%hughhood@earthlink.net>,
 Hugh Hood <hughhood@earthlink.net> wrote:

> 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...

What about a database?
> 
> 
> 
> 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?