Share via

Calculating number of days between two dates

Anonymous
2021-02-04T18:33:43+00:00

Hello

I am using the following formula to calculate the number of days between now and the next pay day.

=DAYS360(B5,B4) where B5 is todays date (using =Date()) and B4 is the next pay date (entered manually).

But it is not adding up - with todays date being 04/02/21 and the next day pay date being 05/03/21 it hould return 29 (the pay dates being every 4 weeks but comes back with 31.  Ive counted on a calendar!

It has alwaysworked up until now.

Am I going mad? Has something changed in the way Excel works? It's not a leap year.

Thanks In advance.

Mark

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2021-02-04T18:38:37+00:00

    DAYS360 bases a month on 30 days, no matter what.  It is really only meant for some accounting calculations.

    You can use simple subtraction, like so:

    =B4-TODAY()

    or

    =B4-TODAY()+1

    depending on whether you want to count today as 0 or 1.

    2 people found this answer helpful.
    0 comments

Answer accepted by question author

  1. DaveM121 870.6K Reputation points Independent Advisor
    2021-02-04T19:09:12+00:00

    Hi Mark

    I am Dave, an Independent Advisor, I will help you with this . . .

    In Cell B5, enter =TODAY()

    In Cell B4, enter the date of your next pay day

    Then, use this formula to calculate the Days to next Pay Day: =B4-B5

    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2021-02-07T23:18:10+00:00

    Ah lovely, thanks for the help!

    0 comments
  2. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more