+ Reply to Thread
Results 1 to 3 of 3

Formula for date minus date = number of days

Hybrid View

  1. #1
    Registered User
    Join Date
    04-28-2006
    Posts
    51

    Formula for date minus date = number of days

    Hi,

    I was wondering if anyone knows how I could enter a date in one cell,
    then another date in a second cell and in a third cell have
    it have it so it minuses the first date from the second and calculates the
    difference outputted in number of days.

    Example:

    04/31/08 - 04/01/08 = 30 (days)

    Thanks for your time.

    Dino
    Last edited by Dno; 11-15-2008 at 03:27 PM.

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    Microsoft 365
    Posts
    14,699
    You can just subtract the earlier date from the later, e.g. if earlier date is in A1 and later date in B1 use this formula in C1

    =B1-A1

    make sure you format C1 as general

  3. #3
    Registered User
    Join Date
    04-28-2006
    Posts
    51
    Aha that was easy. Thanks!

+ 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