Consulting

Results 1 to 3 of 3

Thread: Calculate months onwards from set date

  1. #1

    Calculate months onwards from set date

    Hi
    I am trying to calculate the month in value onwards according to =Today() in a cell

    example , say A1 has 2017/02/01 and B1 has the today() in 2017/04/23

    so the answer in C3 should be 2 and next month the answer should be 3

    C3 =
    HTML Code:
    DATE(YEAR(A1);MONTH(A1)+(B2);DAY(A1))
    , not working
    A1 will always be smaller or equal to B1

    I am trying to avoid the EDATE function as this will be used on different pc's , and not sure if it is installed
    I dont need the years of days to calculate , only months

    Thank you

  2. #2
    VBAX Expert
    Joined
    Sep 2016
    Posts
    788
    Location
    =DATEDIF(A1,B1,"M")

  3. #3
    Thank you , works great

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •