Excel Formula- Having a number automtically divide in half after 6 months

microsoft excelworksheet-function

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:

=IF(TODAY() > A1+182.5, B1/2, B1)

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

A             B          C
11/19/2013    600        300
11/19/2014    600        600

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

=IF(TODAY() > A3+182.5, B3-(B3/2), B3-B3)

In which you get the following:

A             B          C
11/19/2013    600        300
11/19/2014    600        0