Allocating value to a month by anniversary date

Job ID: 38188931

Budget: £10 – £20 GBP

The issue I have is as follows. I have a anniversary date, a starting date and an end date. If the anniversary date falls within the date range I need to have an annual value in.

The date range is 01/01/24 to 31/12/24

If the anniversary date is 25/06/23 and the annual value is 400k, then I need 400k in the june 2024.


Or if the anniversary date is 01/04/2022 and the value is 500k then i need 500k in April 2024
Related categories: Excel Microsoft