software

Hi All.............

Just was working out a problem and in A1 put 12/31/2005
and in B1 put =DAY(A1), formatted as Custom dddd, and the result came out
TUESDAY. Then when I copied both cells down, A2 became 1/1/2006 and B2
became Sunday, as they should be, etc etc on down.........

I dropped down to A8 and entered 12/25/2005 and in B8 put =DAY(A8) and I got
WEDNESDAY. By then copying down, these followed that sequence to 12/3102005
being TUESDAY again and when it switched to 1/1/2006 in A15, then B15 became
Sunday as it should be, and was correct from there on down...........

Anybody know what's up with that?

Vaya con Dios,
Chuck, CABGx3
Nevermind, I see now that I should have used =WEEKDAY(A1) instead of just
DAY(A1)............

Thanks,
Chuck, CABGx3
quot;CLRquot; wrote:

gt; Hi All.............
gt;
gt; Just was working out a problem and in A1 put 12/31/2005
gt; and in B1 put =DAY(A1), formatted as Custom dddd, and the result came out
gt; TUESDAY. Then when I copied both cells down, A2 became 1/1/2006 and B2
gt; became Sunday, as they should be, etc etc on down.........
gt;
gt; I dropped down to A8 and entered 12/25/2005 and in B8 put =DAY(A8) and I got
gt; WEDNESDAY. By then copying down, these followed that sequence to 12/3102005
gt; being TUESDAY again and when it switched to 1/1/2006 in A15, then B15 became
gt; Sunday as it should be, and was correct from there on down...........
gt;
gt; Anybody know what's up with that?
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;

quot;CLRquot; gt; wrote in message
...
gt; Nevermind, I see now that I should have used =WEEKDAY(A1) instead of just
gt; DAY(A1)............

Hi Chuck,

There's somthing about that *Send* button that sharpens your thinking isn't
there? lt;ggt;

--
Regards

Sandy
with @tiscali.co.uk
quot;
LOLOL...........yeah, thanks Sandy...........actually it was one of your
responses to another post that brought me to my quot;sensesquot;, or at least as
close as I get...........

Vaya con Dios,
Chuck, CABGx3
quot;Sandy Mannquot; wrote:

gt; quot;CLRquot; gt; wrote in message
gt; ...
gt; gt; Nevermind, I see now that I should have used =WEEKDAY(A1) instead of just
gt; gt; DAY(A1)............
gt;
gt; Hi Chuck,
gt;
gt; There's somthing about that *Send* button that sharpens your thinking isn't
gt; there? lt;ggt;
gt;
gt; --
gt; Regards
gt;
gt; Sandy
gt;
gt; with @tiscali.co.uk
gt; quot;
gt;
gt;
gt;

Hi Chuck

You don't really need DAY() or WEEKDAY().
Just =A1 formatted as ddd would do.

Happy New Year

--
Regards

Roger Govier
CLR gt; wrote
gt; Nevermind, I see now that I should have used =WEEKDAY(A1) instead of
gt; just DAY(A1)............
gt; Thanks,
gt; Chuck, CABGx3
gt; quot;CLRquot; wrote:
gt;gt; Hi All.............
gt;gt; Just was working out a problem and in A1 put 12/31/2005
gt;gt; and in B1 put =DAY(A1), formatted as Custom dddd, and the result
gt;gt; came out TUESDAY. Then when I copied both cells down, A2 became
gt;gt; 1/1/2006 and B2 became Sunday, as they should be, etc etc on
gt;gt; down......... I dropped down to A8 and entered 12/25/2005 and in
gt;gt; B8 put =DAY(A8) and I got WEDNESDAY. By then copying down, these
gt;gt; followed that sequence to 12/3102005 being TUESDAY again and when
gt;gt; it switched to 1/1/2006 in A15, then B15 became Sunday as it
gt;gt; should be, and was correct from there on down........... Anybody
gt;gt; know what's up with that? Vaya con Dios,
gt;gt; Chuck, CABGx3

Now that quot;reallyquot; makes me feel bad lt;ggt;........

thanks Roger

Vaya con Dios,
Chuck, CABGx3
quot;Roger Govierquot; wrote:

gt; Hi Chuck
gt;
gt; You don't really need DAY() or WEEKDAY().
gt; Just =A1 formatted as ddd would do.
gt;
gt; Happy New Year
gt;
gt; --
gt; Regards
gt;
gt; Roger Govier
gt;
gt;
gt;
gt; CLR gt; wrote
gt; gt; Nevermind, I see now that I should have used =WEEKDAY(A1) instead of
gt; gt; just DAY(A1)............
gt; gt; Thanks,
gt; gt; Chuck, CABGx3
gt; gt; quot;CLRquot; wrote:
gt; gt;gt; Hi All.............
gt; gt;gt; Just was working out a problem and in A1 put 12/31/2005
gt; gt;gt; and in B1 put =DAY(A1), formatted as Custom dddd, and the result
gt; gt;gt; came out TUESDAY. Then when I copied both cells down, A2 became
gt; gt;gt; 1/1/2006 and B2 became Sunday, as they should be, etc etc on
gt; gt;gt; down......... I dropped down to A8 and entered 12/25/2005 and in
gt; gt;gt; B8 put =DAY(A8) and I got WEDNESDAY. By then copying down, these
gt; gt;gt; followed that sequence to 12/3102005 being TUESDAY again and when
gt; gt;gt; it switched to 1/1/2006 in A15, then B15 became Sunday as it
gt; gt;gt; should be, and was correct from there on down........... Anybody
gt; gt;gt; know what's up with that? Vaya con Dios,
gt; gt;gt; Chuck, CABGx3
gt;
gt;
gt;
gt;