Consulting

Results 1 to 4 of 4

Thread: Help Nesting a Formula

  1. #1
    VBAX Regular
    Joined
    Apr 2017
    Location
    Atlanta
    Posts
    81
    Location

    Question Help Nesting a Formula

    I have attached the spreadsheet with the same information below:

    The formula (dates)
    Days Open = Ticket Completed - Ticket Opened - Days On-Hold
    =IF(J6="","",IF(ISBLANK(L6), TODAY()-J6,L6-J6-M6))

    Works as seen, however if Ticket Opened is blank, the formula does not cover that option and the formula does not calculate.

    Next Teachable Moment:
    Can you show me how I would nest a format into the above formula? Instead of showing 109 days, show 1 month 2 days.
    Note, I'm not going to use this format on the table. Instead, I will show this format on the dashboard (I am comfortable with converting). I simply want to learn how this is nested into the above formula.

    Thank you in advance.
    Attached Files Attached Files
    Last edited by jnix612; 11-03-2023 at 01:34 PM.

  2. #2
    VBAX Regular
    Joined
    Apr 2017
    Location
    Atlanta
    Posts
    81
    Location
    Never mind! I can't locate the delete feature here. Please do not reply. I will repost because I just learned there is another date and duration I need to track.

  3. #3
    Moderator VBAX Wizard Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    5,180
    Location
    Sorry jnix612 but this thread will stay open until a solution is found. Others who find themselves with this type of a problem could use this as a learning moment.
    Remember To Do the Following....
    Use [Code].... [/Code] tags when posting code to the thread.
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

  4. #4
    VBAX Sage
    Joined
    Apr 2007
    Location
    United States
    Posts
    8,743
    Location
    Quote Originally Posted by jnix612 View Post
    Never mind! I can't locate the delete feature here. Please do not reply.
    The best you can do is to mark it SOLVED using [Thread Tools] menu above your initial post

    However ..... it might be appropriate to expandon this one if you have additional questions
    ---------------------------------------------------------------------------------------------------------------------

    Paul


    Remember: Tell us WHAT you want to do, not HOW you think you want to do it

    1. Use [CODE] ....[/CODE ] Tags for readability
    [CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
    2. Upload an example
    Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
    3. Mark the thread as [Solved] when you have an answer
    Thread Tools (on the top right corner, above the first message)
    4. Read the Forum FAQ, especially the part about cross-posting in other forums
    http://www.vbaexpress.com/forum/faq...._new_faq_item3

Posting Permissions

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