Excel datevalue function

Question

I need help on a spreadsheet based on dates passing, if possible.

Cell A1 contains an accumulation of hours owed.

Cell B1 needs to reduce the value of cell A1 by 75% when the date 31st august is reached.

Then cell C1 needs to reduce the value of cell B1 50% when the date 31st March is reached

Answer 1

This won't work. for the reason I already explained.

Answer 2

so hopefully this will make it easier to visualise.

E2 is the cell that needs to reduce D2 by 75% on 31st Aug and should be "0" until that date

G2 needs to reduce the value of F2 by 50% on 31st march 25 and should be "0" until that date

H2 will be the final amount of hours owed.

Answer 3

Yes, we can use the TODAY() function for the current date. But you need to know when the value in A1 was created...

Answer 4

I have tried today() as a lookup in cell D1.

I would point out that the year would start from April 1st buidling hours to 31st August 24 and then onto March 31st 25.

I had a go with the below. My issue is once the 31/8 passes A1 has to stay as - 75% and not revert to its original number

=IF(AND (A1>0,(TODAY()>=DATEVALUE("31/08/24"),A1*25%,0)

Answer 5

Do you have a cell that contains the date the value in A1 was entered? Without that, the request is ambiguous. For example, today (28th March, 2024) is before 31st March, 2024 but after 31st August, 2023...