+ Reply to Thread
Results 1 to 5 of 5

Create a day-count-total starting from a set date that will increase by one each day

  1. #1
    Registered User
    Join Date
    02-06-2014
    Location
    Iowa
    MS-Off Ver
    Excel 2011
    Posts
    2

    Create a day-count-total starting from a set date that will increase by one each day

    I'm no wiz when it comes to Excel, so I hope you don't mind my n00bness.

    Column H is the date something was sent out.
    Column I is the date something was returned.
    Column J is the total days between. (I1-H1=J1)

    I want Column J to calculate the total days from the date something was sent out to the current date if Column I is blank.

    Example:

    (H= 06/17/13)(I = 06/24/2013) therefore (J = 7)
    (H= 02/01/14)(I = N/A) if it was today, (J = 5)

    Anyone know how to write a formula like this?
    Last edited by BJ Huckfeldt; 02-06-2014 at 04:15 PM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,897

    Re: Need help writing a formula

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

    Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

    To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,499

    Re: Create a day-count-total starting from a set date that will increase by one each day

    Could something like =IF(I1="",TODAY()-H1,I1-H1) work for you (provided i have your dates in the correct order)?
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  4. #4
    Registered User
    Join Date
    02-06-2014
    Location
    Iowa
    MS-Off Ver
    Excel 2011
    Posts
    2

    Re: Create a day-count-total starting from a set date that will increase by one each day

    Thank you for taking the time. The code works flawlessly. I had a lil' bit of that but you finished it up for me.

    Problem solved.

  5. #5
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,499

    Re: Create a day-count-total starting from a set date that will increase by one each day

    Great! Don't forget to mark your post as solved and I don't mind a bump to my rep if you feel I helped.

    EDIT: Thanks for the add to my reputation!
    Last edited by Sam Capricci; 02-06-2014 at 04:29 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Need help writing a formula...
    By Nchampton in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-04-2007, 10:29 AM
  2. Replies: 2
    Last Post: 01-03-2006, 05:42 PM
  3. Help writing a formula
    By paul in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-06-2005, 06:05 AM
  4. [SOLVED] Help writing a formula
    By Adam in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  5. [SOLVED] Writing a formula
    By julescc in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-03-2005, 12:06 AM

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