Results 1 to 40 of 40

Display Current Date With Specific Formatting In Cell Only Once

Threaded View

swordswinger710 Display Current Date With... 02-28-2012, 12:17 PM
swordswinger710 Re: Display Current Date With... 02-29-2012, 09:19 AM
smuzoen Re: Display Current Date With... 02-29-2012, 09:38 AM
smuzoen Re: Display Current Date With... 02-29-2012, 09:25 AM
Domski Re: Display Current Date With... 02-29-2012, 09:28 AM
swordswinger710 Re: Display Current Date With... 02-29-2012, 09:28 AM
Domski Re: Display Current Date With... 02-29-2012, 09:30 AM
GirlGeek123 Re: Display Current Date With... 02-29-2012, 10:18 AM
swordswinger710 Re: Display Current Date With... 02-29-2012, 10:00 AM
Domski Re: Display Current Date With... 02-29-2012, 10:09 AM
OnErrorGoto0 Re: Display Current Date With... 02-29-2012, 10:05 AM
Domski Re: Display Current Date With... 02-29-2012, 10:06 AM
snb Re: Display Current Date With... 02-29-2012, 10:07 AM
smuzoen Re: Display Current Date With... 02-29-2012, 10:15 AM
swordswinger710 Re: Display Current Date With... 02-29-2012, 10:21 AM
Domski Re: Display Current Date With... 02-29-2012, 10:26 AM
OnErrorGoto0 Re: Display Current Date With... 02-29-2012, 10:28 AM
swordswinger710 Re: Display Current Date With... 02-29-2012, 11:20 AM
OnErrorGoto0 Re: Display Current Date With... 02-29-2012, 11:23 AM
swordswinger710 Re: Display Current Date With... 02-29-2012, 11:26 AM
Domski Re: Display Current Date With... 02-29-2012, 11:38 AM
snb Re: Display Current Date With... 02-29-2012, 11:43 AM
swordswinger710 Re: Display Current Date With... 02-29-2012, 11:56 AM
swordswinger710 Re: Display Current Date With... 02-29-2012, 01:07 PM
Domski Re: Display Current Date With... 02-29-2012, 03:29 PM
swordswinger710 Re: Display Current Date With... 02-29-2012, 04:01 PM
swordswinger710 Re: Display Current Date With... 03-01-2012, 11:17 AM
Domski Re: Display Current Date With... 03-01-2012, 11:23 AM
swordswinger710 Re: Display Current Date With... 03-01-2012, 11:34 AM
snb Re: Display Current Date With... 03-01-2012, 11:44 AM
swordswinger710 Re: Display Current Date With... 03-01-2012, 11:59 AM
snb Re: Display Current Date With... 03-01-2012, 12:10 PM
swordswinger710 Re: Display Current Date With... 03-01-2012, 12:21 PM
swordswinger710 Re: Display Current Date With... 03-01-2012, 04:08 PM
snb Re: Display Current Date With... 03-01-2012, 04:49 PM
swordswinger710 Re: Display Current Date With... 03-01-2012, 05:05 PM
snb Re: Display Current Date With... 03-01-2012, 05:35 PM
swordswinger710 Re: Display Current Date With... 03-01-2012, 05:59 PM
snb Re: Display Current Date With... 03-02-2012, 04:01 AM
swordswinger710 Re: Display Current Date With... 03-02-2012, 12:49 PM
  1. #1
    Forum Contributor swordswinger710's Avatar
    Join Date
    02-20-2008
    Location
    Bright, Canada
    MS-Off Ver
    2010
    Posts
    845

    Question Display Current Date With Specific Formatting In Cell Only Once

    I have a blank template workbook containing several sheets which gets copied, filled out, and saved many times. One of the sheets in this workbook has a 'Date' cell on it which needs to display the date on which the rest of that sheet gets filled out, but it shouldn't change if the sheet receives changes later on. The format of the date cell should read, for example; Feb 28, 2012.

    I've been trying to figure out how to do this, and I think I've got something - one of the other cells on this particular sheet will receive a data entry once, at the 'creation' of a fresh copy of this template. This cell - Cell L3:Q3 - will not be changed at any further time, as most of the other cells may be subject to. My thought is this: Upon the data entry into the L3:Q3 cell, the date cell - AA1:AC1 - would get the current date inserted into it, and wouldn't change again, unless somebody wanted to manually do so.

    How could I do this?
    Last edited by swordswinger710; 03-01-2012 at 05:10 PM.
    There is so much good in the worst of us,
    And so much bad in the best of us,
    That it hardly behooves any of us
    To talk about the rest of us.

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