In a spreadsheet I have a desired cost programme - ie the cost has to be spent in that given period.
And detailed breakdown of the cost.
How do I ensure check that the cost are always within required quarter.
In the attached, the cost for row 25 starts on Jun-21 quarter and but should be one quarter before that based on the value of E25 (As this is error on some formula say in A25 like if cost start and finish within the quarter then True else false)
Also, the value on row 23, should finish on the Mar-21 quarter (based on the value of E18) but finishes one quarter late.
Bookmarks