Weekly CF into Daily CF (by dates, divided by 7)

[jlmre00]

Hi all!

BACKGROUND: I have a [ Weekly CF totals ] that I needs to be converted into [ Daily CF ] by dates. It could be a straight line division by 7

PROBLEM: tried LOOKUP and IF statements and even intermediate support calcs but not getting the #'s shows up in the right dates

Please see the screen shot

Thank you in advance!

 

[Fluff]

That file is coming as unauthorized. You need to mark it for sharing & then post the link you given.

 

[jlmre00]

That file is coming as unauthorized. You need to mark it for sharing & then post the link you given.

Understood. Thanks. Changed to 'anyone can see it who has a link' - let me know if that works: https://docs.google.com/spreadsheet...ouid=118304745498552023203&rtpof=true&sd=true

 

[Fluff]

That's fine, thanks.

 

[jlmre00]

In D34 of Daily sheet, Copied across. In 2025 2026 Sales Projections range taken up to BM. If required change it.

=IFERROR(INDEX('2025 2026 Sales Projections'!$D$28:$BM$28,AGGREGATE(15,6,COLUMN('2025 2026 Sales Projections'!$D$27:$BM$27)/('2025 2026 Sales Projections'!$D$27:$BM$27>=D$12),1)-COLUMN($C$28)),"")

I slightly adjusted this and it worked!! Thank you very much!!

 

[Peter_SSs]

I slightly adjusted this and it worked!! Thank you very much!!

Since the earlier post contained the gist of the solution the marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.