Results 1 to 4 of 4

Thread: Automatic quarterly date change

  1. #1
    Seeker Luigi802's Avatar
    Join Date
    Aug 2016
    Posts
    12
    Articles
    0
    Excel Version
    2016

    Automatic quarterly date change



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have city bills due every quarter so I went to create a date that will automatically change for their due date.
    Fit example my first trash bill this year was due February 17, 2021 so the next due date was May 17, 2021 and after that August 17, 2021. Based on the current date May 4, 2021 it should say August 17, 2021..... And then automatically change after that based on whatever the current date is..,... Does that make sense?

    Sent from my Pixel 5 using Tapatalk

  2. #2
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,661
    Articles
    0
    Excel Version
    Office 365 Subscription
    Why should it say that the next date is in August on 04 May when 17 May has not yet passed?
    Ali
    Enthusiastic self-taught user of MS Excel!

  3. #3
    Seeker Luigi802's Avatar
    Join Date
    Aug 2016
    Posts
    12
    Articles
    0
    Excel Version
    2016
    Quote Originally Posted by AliGW View Post
    Why should it say that the next date is in August on 04 May when 17 May has not yet passed?
    Well true that was a mistake it should say may 17 now but after that it should say August 17

    Sent from my Pixel 5 using Tapatalk

  4. #4
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,948
    Articles
    0
    Excel Version
    365
    If cell D7 contains the date of a past bill, then in any other cell:
    =EDATE(D7,3*(QUOTIENT(DATEDIF(D7,TODAY(),"M"),3)+1))
    will give you the date of the next bill after today.
    On the date of the next bill, the value will flip to the next one.
    I'm sure it could be more elegant, but it's the first one that worked.

Posting Permissions

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