how to change DATE to WEEK in EXCEL

Discussion in 'Computer Information' started by Tones, Oct 17, 2004.

  1. Tones

    Tones Guest

    hi all

    does anyone know if there is a function in EXCEL which can automatically
    show you the calendar week once you type in a DATE?
    e.g. if you typed in "1-Jan" in one cell, it would display "wk01" in
    another.


    br
    tones
     
    Tones, Oct 17, 2004
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. jasonwoodrun

    Excel date mystery

    jasonwoodrun, Mar 8, 2006, in forum: Computer Support
    Replies:
    11
    Views:
    701
    Dan Evans
    Mar 10, 2006
  2. Craig Shore

    Date sorting in excel

    Craig Shore, Dec 20, 2005, in forum: NZ Computing
    Replies:
    5
    Views:
    578
  3. Tony Neville
    Replies:
    7
    Views:
    1,704
    steve
    Sep 22, 2006
  4. Replies:
    1
    Views:
    360
  5. gary

    "Date Photo taken" date change and deleted photos

    gary, Jan 5, 2013, in forum: Digital Photography
    Replies:
    8
    Views:
    378
Loading...

Share This Page