Results 1 to 6 of 6

How to Calculate Date Differnce in days, weeks or months

Threaded View

  1. 01-13-2024, 05:21 PM #1
    carlton7372
    carlton7372 is offline
    Registered User
    Join Date
    09-14-2015
    Location
    London, England
    MS-Off Ver
    2010
    Posts
    84

    How to Calculate Date Differnce in days, weeks or months

    Can someone help me create a formula to help calculate the date difference between Weeks, Days, and Months(excluding time)

    I have included a sample xlsx file with sample date. I tried with the following but it failed.
    1/23/2024, 12:00 AM 1/31/2024, 12:00 AM
    =(DATEDIF(A1,B1,"d")/7)
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« 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. Calculate weeks if date is less than 7 days from end of month
    By marcquey in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-01-2021, 07:17 AM
  2. Count days, weeks and months between date range
    By ExcelRules2020 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-06-2020, 09:43 PM
  3. Calculate Number of weeks/months falls under each year between date range
    By dhitpit in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-12-2017, 10:06 AM
  4. [SOLVED] conditional formatting of cell = multiple of ref date recurring ( Days or Weeks or Months)
    By Belta in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 02-22-2017, 04:51 AM
  5. [SOLVED] Calculate date based on number of weeks or months after start date
    By wotsup in forum Excel General
    Replies: 3
    Last Post: 08-17-2012, 06:00 AM
  6. [SOLVED] HOW DO I CALCULATE THE YEARS MONTHS AND DAYS BETWEEN SEVERAL DATE
    By Susan in forum Excel General
    Replies: 1
    Last Post: 06-29-2006, 09:30 AM
  7. [SOLVED] How do I sort by date (not days, weeks, months) in Excel 2000?
    By Tony in forum Excel General
    Replies: 1
    Last Post: 01-21-2005, 12:06 PM

Tags for this Thread

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