I'm tracking Transitional Housing in a Microsoft Excel- we pay a client's full rent for 6 months, and then half of that for the following 3. Is there a simple excel formula that can automatically half the rent number shown in excel after the 6 month mark?

Thanks so much!

## Best Answer

I would put the date of origin of the rent in a column (A), and then the full rent in a column (B). Then I would put Current Rent in column C, and I would fill the cells in column C with the following formula:

I use 182.5 for half a year. That way, you get the following:

In this case, C represents the amount of rent that you're covering for the client. If you'd rather have the amount of rent expected from the client, this would work

In which you get the following: