+ Reply to Thread
Results 1 to 6 of 6

How do return days,week no,month and year in between two dates

  1. 10-25-2016, 08:58 AM #1
    silambarasan.J
    silambarasan.J is offline
    Forum Contributor
    Join Date
    08-07-2014
    Location
    India
    MS-Off Ver
    2007
    Posts
    372

    How do return days,week no,month and year in between two dates

    Hi Forum Leader,

    How do return Day,Week No,Month and Year in between two days. Every time i have calculated manually all of thing.

    Start Date End Date Results(Days,Week No,Month,Year)

    09/08/2016 25/10/2016 77 Days,11 Weeks,Month 2,0 Year

    15/04/2016 26/10/2016 11 Days,----------,6 Months,6 Years.

    01/01/2015 31/12/2015 365 Days,52 Weeks,12 Months,1 years.

    Please help me.
    Reply With QuoteRegister To Reply
  2. 10-25-2016, 09:03 AM #2
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,460

    Re: How do return days,week no,month and year in between two dates

    You can concatenate a combination of formulae:

    =DATEDIF(A1,B1,"d")

    =DATEDIF(A1,B1,"d")/7

    =DATEDIF(A1,B1,"m")

    =DATEDIF(A1,B1,"y")


    =DATEDIF(A1,B1,"d")&" days, "&DATEDIF(A1,B1,"d")/7&" weeks, "&DATEDIF(A1,B1,"m")&" months, "&DATEDIF(A1,B1,"y")&" years"
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 10-25-2016, 02:38 PM #3
    silambarasan.J
    silambarasan.J is offline
    Forum Contributor
    Join Date
    08-07-2014
    Location
    India
    MS-Off Ver
    2007
    Posts
    372

    Re: How do return days,week no,month and year in between two dates

    AliGW SIR,

    sorry for the late reply.thank you so much for your help.but how do roundup.

    START DATE DATE RESULT (DD/WS/MM/YYYY)

    09/08/2016 24/10/2016 76 Days, 10.8571428571429 Weeks, 2 Months, 0 Years
    Reply With QuoteRegister To Reply
  4. 10-25-2016, 04:35 PM #4
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,460

    Re: How do return days,week no,month and year in between two dates

    Glad it helped!

    Try this for the weeks:

    =ROUNDUP(DATEDIF(A1,B1,"d")/7,0)
    Reply With QuoteRegister To Reply
  5. 10-26-2016, 04:11 AM #5
    silambarasan.J
    silambarasan.J is offline
    Forum Contributor
    Join Date
    08-07-2014
    Location
    India
    MS-Off Ver
    2007
    Posts
    372

    Re: How do return days,week no,month and year in between two dates

    Perfect.

    Thank you so much for your help.
    Reply With QuoteRegister To Reply
  6. 10-26-2016, 04:29 AM #6
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,460

    Re: How do return days,week no,month and year in between two dates

    You're welcome!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Return averages based on day, week, month and year, from dates in column.
    By koalamotorsport in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-25-2016, 11:11 PM
  2. Days of the month and week based on name month/year
    By RickMcc in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-01-2016, 03:22 PM
  3. [SOLVED] Formula for counting rain days of the year, month, and or week
    By dedark05 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 05-24-2016, 01:27 AM
  4. find time left in month.days unit between two dates(in YEAR.MONTH.DAY)
    By xcfeng95 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 02-21-2014, 12:55 PM
  5. Return value of the last week of the month based on the year and month
    By stevekho2 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-14-2013, 11:04 AM
  6. Excel 2007 : Duration Between Two Dates In Month, Week And Days
    By aduka_irwana in forum Excel General
    Replies: 4
    Last Post: 02-24-2012, 11:06 AM
  7. Drop days from dates to just month and year
    By mrrpv in forum Excel General
    Replies: 2
    Last Post: 02-01-2007, 12:49 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1