+ Reply to Thread
Results 1 to 5 of 5

auto day and date change

Hybrid View

  1. 03-03-2014, 04:18 AM #1
    Daniel290670
    Daniel290670 is offline
    Registered User
    Join Date
    03-03-2014
    Location
    Sydney
    MS-Off Ver
    Office 2010
    Posts
    2

    auto day and date change

    i would like to be able to input the Day and date in coloumn A and have the rest change accordingly
    i wish to have it displayed as follows Monday 03/03/2014 followed by coloumn 2....Tuesday 04/03/2014.
    there are 4 cells for each day set that have been "Merged and Centred". (B2,C2,D2,E2) display "Monday 03/03/2014" , F2 is a split , (G2,H2,I2,J2) display "Tuesday 04/03/2014" and so on.

    i can make the dates change according to the first input but since i must also display the day as well i'm a bit lost.

    thank you in advance for your help.
    Last edited by Daniel290670; 03-03-2014 at 04:21 AM.
    Reply With QuoteRegister To Reply
  2. 03-03-2014, 04:42 AM #2
    alvin-chung
    alvin-chung is offline
    Valued Forum Contributor
    Join Date
    12-25-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2016
    Posts
    506

    Re: auto day and date change

    Hi Daniel290670, it seems to me that you're looking for the custom format "dddd dd/mm/yyyy"?


    _______________________________________________________________________________________________________________________________
    1. Click on the * Add Reputation if you think someone helped you
    2. Mark your thread as SOLVED when question is resolved

    Alvin
    Reply With QuoteRegister To Reply
  3. 03-11-2014, 10:41 PM #3
    Daniel290670
    Daniel290670 is offline
    Registered User
    Join Date
    03-03-2014
    Location
    Sydney
    MS-Off Ver
    Office 2010
    Posts
    2

    Re: auto day and date change

    thank you Alvin. i will try this out
    Reply With QuoteRegister To Reply
  4. 03-03-2014, 04:42 AM #4
    alvin-chung
    alvin-chung is offline
    Valued Forum Contributor
    Join Date
    12-25-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2016
    Posts
    506

    Re: auto day and date change

    Hi Daniel290670, it seems to me that you're looking for the custom format "dddd dd/mm/yyyy"?


    _______________________________________________________________________________________________________________________________
    1. Click on the * Add Reputation if you think someone helped you
    2. Mark your thread as SOLVED when question is resolved

    Alvin
    Reply With QuoteRegister To Reply
  5. 03-15-2014, 10:26 AM #5
    alvin-chung
    alvin-chung is offline
    Valued Forum Contributor
    Join Date
    12-25-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2016
    Posts
    506

    Re: auto day and date change

    You're welcome, good luck


    _______________________________________________________________________________________________________________________________
    1. Click on the * Add Reputation if you think someone helped you
    2. Mark your thread as SOLVED when question is resolved

    Alvin
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel 2007 : I cant auto change a date colour referanced to todays date
    By donjjjordan in forum Excel General
    Replies: 3
    Last Post: 05-17-2011, 09:44 AM
  2. How to get date to auto change for bills
    By skullzy in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 11-29-2009, 04:55 PM
  3. auto date change
    By daveboggs in forum Excel General
    Replies: 1
    Last Post: 06-07-2006, 10:10 AM
  4. Auto date entry for status change
    By Alec H in forum Excel General
    Replies: 2
    Last Post: 02-06-2006, 08:41 PM
  5. [SOLVED] date auto change
    By Colin2u in forum Excel General
    Replies: 3
    Last Post: 08-21-2005, 01:05 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1