+ Reply to Thread
Results 1 to 3 of 3

Excel 2008 : How to count dates assuming that the year changes?

  1. #1
    Registered User
    Join Date
    03-08-2012
    Location
    Zuneid Sidat
    MS-Off Ver
    Excel 2011 Mac
    Posts
    5

    How to count dates assuming that the year changes?

    I am creating a table which looks like this

    A1: 15/12/2011
    B1: 31/01/2012
    C1: Today()
    D1: In this cell i want to count the days from C1 to reach B1. The problem is, i want him to assume has continuous years. For example. Today is 08/03/2012. I want to count assuming that B1 is 2013, after C1 round again and passes B1 assume 2014, continuing until...

    Thanks

  2. #2
    Forum Expert OnErrorGoto0's Avatar
    Join Date
    12-30-2011
    Location
    I DO NOT POST HERE ANYMORE
    MS-Off Ver
    I DO NOT POST HERE ANYMORE
    Posts
    1,655

    Re: How to count dates assuming that the year changes?

    Try:
    =IF(C1<B1,B1-C1,DATE(YEAR(B1)+1,MONTH(B1),DAY(B1))-C1)
    in D1.
    Good luck.

  3. #3
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675

    Re: How to count dates assuming that the year changes?

    Seems to be a duplicate
    Audere est facere

+ 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