+ Reply to Thread
Results 1 to 4 of 4

trying to get day/month/year froamt while user enters year only

  1. #1
    RADIOOZ
    Guest

    trying to get day/month/year froamt while user enters year only

    I am trying to get the end user to enter the year in question and then have
    the document return values in column A in dd/mmm/yyyy format and column B
    in Day of week format for all days in that year

  2. #2
    Bob Phillips
    Guest

    Re: trying to get day/month/year froamt while user enters year only

    You would just use something like

    =DATE(2006,1,ROW())

    copied down, but I am not clear where the year number is stored, and when
    the flip to column B happens.

    --
    HTH

    Bob Phillips

    (replace somewhere in email address with gmail if mailing direct)

    "RADIOOZ" <[email protected]> wrote in message
    news:[email protected]...
    > I am trying to get the end user to enter the year in question and then

    have
    > the document return values in column A in dd/mmm/yyyy format and column

    B
    > in Day of week format for all days in that year




  3. #3
    Marcelo
    Guest

    RE: trying to get day/month/year froamt while user enters year only

    Hi Radiooz,

    Assuming that you have the year on A1,

    on A2 you can use the formula =Date(a1,1,1) and it will return 01/Jan/aaaa.
    on A3 the formula could be =A2+1
    on A4 the formula could be =A3+1
    etc...

    Just format it as your convenience

    for the B Column, =weekday(a2). format it as "ddd" for Sun or "dddd" for
    Sunday.

    hope it heps.
    regards from Brazil
    Marcelo




    "RADIOOZ" escreveu:

    > I am trying to get the end user to enter the year in question and then have
    > the document return values in column A in dd/mmm/yyyy format and column B
    > in Day of week format for all days in that year


  4. #4
    RADIOOZ
    Guest

    RE: trying to get day/month/year froamt while user enters year onl

    Thanks Marcelo
    just what I wanted

    "Marcelo" wrote:

    > Hi Radiooz,
    >
    > Assuming that you have the year on A1,
    >
    > on A2 you can use the formula =Date(a1,1,1) and it will return 01/Jan/aaaa.
    > on A3 the formula could be =A2+1
    > on A4 the formula could be =A3+1
    > etc...
    >
    > Just format it as your convenience
    >
    > for the B Column, =weekday(a2). format it as "ddd" for Sun or "dddd" for
    > Sunday.
    >
    > hope it heps.
    > regards from Brazil
    > Marcelo
    >
    >
    >
    >
    > "RADIOOZ" escreveu:
    >
    > > I am trying to get the end user to enter the year in question and then have
    > > the document return values in column A in dd/mmm/yyyy format and column B
    > > in Day of week format for all days in that year


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1