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!

 

[kvsrinivasamurthy]

Both data are in same sheet or different. Pl give example of data in XL2BB format.

 

[kvsrinivasamurthy]

If possible upload a sample file in some website and give link here.

 

[jlmre00]

If possible upload a sample file in some website and give link here.

Thanks for looking at this. I manually entered the info (using Index Match for supporting calcs, then copy paste). But. Would love to know how it can be done with syntax Loading Google Sheets

 

[jlmre00]

Both data are in same sheet or different. Pl give example of data in XL2BB format.

It’s in the same workbook, 2 different tabs - please see the screen shot in my other reply to you and uploaded excel into google drive with the link posted

 

[jlmre00]

If possible upload a sample file in some website and give link here.

Just saw your request. You should have access now. Let me know if you don't

 

[kvsrinivasamurthy]

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)),"")

 

[kvsrinivasamurthy]

For 365 version in D34. Formula spills over up to column ABP.

=LET(a,D12:ABP12,b,'2025 2026 Sales Projections'!D27:BM27,c,'2025 2026 Sales Projections'!D28:BM28,BYCOL(a,LAMBDA(Clm,IF(Clm="","",IFERROR(INDEX(c,AGGREGATE(15,6,COLUMN(b)/(b>=Clm),1)-COLUMN($C$28)),"")))))

 

[kvsrinivasamurthy]

For other than 365 version. In D34 copied across.

=IF(D$12="","",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)),""))

 

[jlmre00]

Thank you very much! For some reason you used 2024 dates as well from Sales Projections. Those 2024 dates line (in Sales Projections 2025) I should have deleted it, sorry. Pls see 1st screen shot.

Could you please take a look at the updated workbook and see if you can connect [ Sales Forecast (Tab) 2025 Web Sales (line 8) to Daily (tab) Web Sales (line 23). I re-created the Forecast in a difference tab (making it cleaner). Pls see 2nd screen shot.

Updated workbook: Loading Google Sheets