Results 1 to 6 of 6

Thread: Formula that returns the date that a criteria is met

  1. #1
    Seeker zachpenrod's Avatar
    Join Date
    Jun 2018
    Posts
    5
    Articles
    0
    Excel Version
    2010

    Formula that returns the date that a criteria is met



    Register for a FREE account, and/
    or Log in to avoid these ads!

    My journal entries have two dates. One is the date I want it to show up in the system. The second date is the actual date I loaded the journal entry. I would like to create a formula that shows the date I loaded the entry. A document number is created within my spreadsheet once I load the entry so I'm thinking I could base the formula on if that cell is populated or not. The part that is hanging me up is that essentially I want the formula result to not change once there is a document number.

  2. #2
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,250
    Articles
    0
    Excel Version
    Office 365 Subscription
    To help, we shall need to know the layout of the data.
    Ali
    Enthusiastic self-taught user of MS Excel!

  3. #3
    Seeker zachpenrod's Avatar
    Join Date
    Jun 2018
    Posts
    5
    Articles
    0
    Excel Version
    2010
    Click image for larger version. 

Name:	JE Header.jpg 
Views:	14 
Size:	25.7 KB 
ID:	8337

    Here's a screenshot of the header I'm working with. The document date is the date I want to show when I loaded the JE. The Posting date is hardcoded and always the last day of the month. The document number is the field that is auto populated with a number once I load the JE.

  4. #4
    Administrator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,673
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Hi and welcome

    please post a small sample sheet with some data and expected results. We cannot work on an image ( click Go advanced - Manage attachments)
    Thank you Ken for this secure forum.

  5. #5
    Seeker zachpenrod's Avatar
    Join Date
    Jun 2018
    Posts
    5
    Articles
    0
    Excel Version
    2010
    See attached example.
    Attached Files Attached Files

  6. #6

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •