Allocating value to a month by anniversary date
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
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