Comments on: How to calculate days between dates in Excel

Are you wondering how many days are between two dates? Maybe, you need to know the number of days between today and some specific date in the past or future? Or, you just want to count working days between two dates? Whatever your task is, one of the below examples will certainly provide the solution. Continue reading →

Comments page 2. Total comments: 86

  1. Dear Sir,

    I am ins search with a formula which can be used for - difference or Addition between 2 dates with outocme in Date only

  2. How do I calculate days between two dates in Excel(in solar calendar)

  3. Sir I want to Calculate number of days between start date & time to end date & time i.e 20-11-2020 07:00 am to 21-11-2020 07:00 am 1 day if date 21-11-2020 07:01 am then 2 days it will show if DATE IS 20-11-2020 time is any time after 07:00 am to 21-11-2020 07:00 am it calculate 1 days after 07:00 am it calculate 2 days automatically can you help me ?

    1. Hello!
      What formula are you using? What format is set in a cell with a formula? Remember that dates and times are recorded in Excel as numbers.

  4. In excel 2007 database.
    I have current date in column A, there are also dates in columns AH, AX, BI and BS.
    It would be very useful if I can replace date with days between A and each of the other 4. so number of days between A and AH, A and AX, A and BI, and A and BS. Since there are in excess of 30000 rows, it would be useful to automatically calculate the days for each row with a single formula!
    Found your articles very informative and hope you can assist with this rather strange request.
    Many thanks in anticipation,
    Stay safe,
    Regards,
    Doug

    1. Hello!
      Unfortunately, you can only replace the date in a cell with the number of days using a VBA macro. If a cell contains a date, then it is no longer possible to write a formula to it.
      If there is anything else I can help you with, please let me know.

  5. As an example, let's calculate the difference between today and an earlier date in A4:

    =TODAY() - A4

    From the above example I am trying to calculate the number of working days.
    The date Column1
    21/10/2020 In this column I would like to display the number of working days from 24/10/2020 till today

    Please help.

  6. I would like a formula to calculate 21 working days from any given date, can you help please

  7. I have four columns with dates. First column in date of receipt(7/1/20), second column is date of 1st response (7/5/20), third column is IF a 2nd response is needed and fourth column is IF a third response is needed. I need a column that totals # of days from date of receipt until last response (whether 1, 2, or 3). How do I build a formula for that?

    1. Hello!
      If I understand your task correctly, the following formula should work for you:

      =MAX(A1:D1)-A1

      Hope this is what you need.

  8. I have 5 customer transactions, each on different days, displayed on different rows, there is a common customer ID - i want to understand how many days from the earliest transaction date to the most recent transaction date. ie. Calculating customer lifetime in days. Help? Thanks!

    1. Note - i could have 20k rows of customer data so cannot manually take dates to calculate. Needs to be something like IF Customer ID = "Customer ID", calculate days between Newer Date and Older Date...

  9. date + days = count date
    02/06/20 + 5 = 06/06/20

    1. Hello!
      Your date 02/06/20 in its entirety looks like this: 02/06/20 00:00:00. Therefore, when you add 5 days, one of them is 02/06/2020. And then add another 4 days. We get 06/06/20

    2. plz help for how to cakculate ??

  10. I want formula for counting days between two dates. In case of from date and to date are same so here the number of days is 1. But all above formula shows 0.

    1. =IF(AND(A=E,B=F,C=G),1,difference formula)
      here A,B,C contains date 1 and E,F,G contains second date.

  11. Hi

    I am trying to total the number of days a certain job takes to do. However if the task is done in the same day how do I get excel to count this as 1 day?

    Any feedback would be super - thank you
    Danielle

    1. Hi Danielle,

      Assuming that your dates and in A and B columns, the formula below should work for you:
      =IF(B1 = A1, 1, B1-A1)

      Just enter this formula in C1 and then copy it along the column.

      1. What if I wanted to use this formula with "B1" being "Today"? I can't seem to make that work.

  12. I need to know the day of the date in one coloumn
    for Example 23/10/2018 what would be the Day?

    For the 100 lines i will have the dates, i need to find the day

    1. Hello, Prema.
      Thank you for contacting us and for your question.

      If you need to replace 23/10/2018 with the corresponding day of the week, you just need to select your cells, then press Ctrl+1 to open the Format Cells dialog. On the Number tab, select Custom from the Category list and type the following date format: dddd

      You can learn more about date formats in Excel in this article on our blog.

      Hope you’ll find this information helpful.

  13. Could you please help me with the formula to work out how many days between dates, but if there is no start date (yet) to display 0 instead of 43388

    1. Hello,
      Please try the following formula:
      =IF(ISBLANK(A1), 0, DATEDIF(A1,B1,"d"))

      You can also learn about Excel date functions in Excel in this article on our blog.

      Hope you’ll find this information helpful.

      1. Thank you Mam..

      2. Excellent, thank you; just what I needed - the date difference and a zeroed-out field while only the start date is currently known.

      3. When one column date is 30/6/2019 and once column is blank (no date) then how to check difference between two columns , i need result "0" if any formula try to check two columns difference

  14. In testing, it appears the DATEDIF does not compute date values prior to Jan 1, 1900. What's the solution for computing date different (age, for example), if the birth date is in the late 1800s?

Post a comment



Thanks for your comment! Please note that all comments are pre-moderated, and off-topic ones may be deleted.
For faster help, please keep your question clear and concise. While we can't guarantee a reply to every question, we'll do our best to respond :)