Calculating RUBS base on date changes

MS 20 Reputation points
2026-08-18T22:48:27.27+00:00

I want to calculate RUBS base on January 1st, and July 1st rates updated.

Based on current date, spreadsheet calculates RUBS for the 1st of the year or for the midyear update.

Thank you.

Microsoft 365 and Office | Excel | For business | Windows
Answer accepted by question author
Ashish Mathur 102.4K Reputation points Volunteer Moderator
2026-08-18T23:51:03.79+00:00

Hi,

Enter this formula in cell C8

=XLOOKUP(B8,A2:A3,B2:B3,,-1)*A8

Hope this helps.

User's image

Was this answer helpful?

1 person found this answer helpful.

1 additional answer

Sort by: Newest
Most helpful Newest Oldest
  1. MS 20 Reputation points
    2026-08-18T23:45:59.0333333+00:00

    Hello,

    Yes, essentially what I want to be able to do is have a date formula that I can use to update for RUBS specifically a water rate changes for 1/1/2026 and 7/1/2026.

    For example,

    Data:

    January 1st through June rate was 3%.

    July 1st comes around, the rate changed from 3% to 3.2%.

    I wanted to be able to build a formula that when I enter the date of say July 1st (7/1/2026, can be in this format), that it calculates the costs based on the rate and dates.

    Thank you

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.