+ Reply to Thread
Results 1 to 5 of 5

Auto Populate Day Date and year

  1. #1
    Registered User
    Join Date
    09-11-2012
    Location
    uk
    MS-Off Ver
    Excel 2003
    Posts
    3

    Auto Populate Day Date and year

    Hello can someone please point me in the direction of a code to do the following?
    I have made a simple spreadsheet to capture data from Monday to Saturday
    Mon is in A2 Tues in A12 ect.what I would like to acheive is for the day and date to auto populate correctly to save manually inputing this data on a weekly basis.
    Thanks and Regards John

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,448

    Re: Auto Populate Day Date and year

    Hi
    could you post an example of what you want please? ( a small sample sheet will do) Thx

  3. #3
    Registered User
    Join Date
    09-11-2012
    Location
    uk
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Auto Populate Day Date and year

    Hi I have Cell A2 That yesterday i typed Monday 10/09/2012 in cell A12 today i typed Tuesday 11/09/2012...
    Next week I will just make a copy of my blank master and call it DATA WC 17/09/2012 and do this weekly,now I'm very new to Excel and am sure there is a way for this simple spreadsheet to auto populate I'll try to attach it

  4. #4
    Registered User
    Join Date
    09-11-2012
    Location
    uk
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Auto Populate Day Date and year

    Hi this is my spreadsheet Mon is A2.Thanks in advance

  5. #5
    Registered User
    Join Date
    08-27-2010
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    76

    Re: Auto Populate Day Date and year

    A19=A2+1

    Then format date for your preferred view.

    Copy of Daily Jobs issued TRACKER 15R WC 10-09-2012.xlsx

+ 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