+ Reply to Thread
Results 1 to 2 of 2

How do you add a date stamp to one cell once another is populated?

  1. #1
    Registered User
    Join Date
    08-08-2012
    Location
    New York
    MS-Off Ver
    Excel 2007
    Posts
    1

    How do you add a date stamp to one cell once another is populated?

    Good Day!

    I am setting up a worksheet and I need the date in cell C2 to set to the date tin which cell V2 is populated; and the rows that proceed. The worksheet will have rows that represent individual items that need to be reviewed. Once the user reviews the line item they will input their initials into Column V and I would like the date in which they reviewed the item to set in Column C. How would I go about setting this up?

    In addition to this, is there a way to count the number of WORKDAYS in between two dates and have that value input into a cell (in Column A). For example in this same workbook... I need to count the number of days between the date the item was reported (Column B) and the date it was reviewed (Column C); in order to determine the average review time of the items.

    Summary of the main worksheet columns is below:

    Column A: Count of days between date reported and date reviewed.
    Column B: Date Item Reported
    Column C: Date Item Reviewed
    Column D: Item Description
    Column V: Initials of Associate Who Reviewed the Item

    Any help would be greatly appreciated!!

  2. #2
    Forum Contributor day92's Avatar
    Join Date
    04-20-2010
    Location
    Los Angeles
    MS-Off Ver
    Excel 360
    Posts
    600

    Re: How do you add a date stamp to one cell once another is populated?

    Hi Mal and welcome to the forum. It seems like you can accomplish A with a networking days formula, and B & D with a vlookup. Im not sure what you mean by Date Item Reviewed and Initials of Associate Who Reviewed the Item - seems like they can just type that in right?

    Do you have a sample workbook of what you are trying to accomplish?

+ 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