+ Reply to Thread
Results 1 to 2 of 2

Number of days between 2 dates, if end date is blank assume todays

  1. #1
    JulesM
    Guest

    Number of days between 2 dates, if end date is blank assume todays

    I need an excel formula to calculated the number of days between 'Start Date'
    and 'End Date'. IF the 'End Date' is null I want to use todays date.

    Please Help

  2. #2
    Niek Otten
    Guest

    Re: Number of days between 2 dates, if end date is blank assume todays

    =IF(B1="",TODAY(),B1)-A1
    Format as number, not as date (which Excel will do automatically)

    --
    Kind regards,

    Niek Otten

    "JulesM" <JulesM@discussions.microsoft.com> wrote in message
    news:3F72EC08-8C4A-4B52-96AC-BE4D29174DD2@microsoft.com...
    >I need an excel formula to calculated the number of days between 'Start
    >Date'
    > and 'End Date'. IF the 'End Date' is null I want to use todays date.
    >
    > Please Help




+ 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