13 Week Cash Flow Forecast model
Hi,
I have purchased the 13 cash flow forecasting course by WSO. On the personal cash flow forecast there is a formula to allocate expense in the correct weekly time period. No matter what I do with cell refencing, It seem to not be pulling values through, any ideas why?
=IF(AND('Assumptions '!$D28>=DAY('TWCF Model'!C$6),'Assumptions '!$D28<=DAY('TWCF Model'!C$7)),'Assumptions '!$C28,0)
Assumptions '!$D28 = Date of month for Expense Assumptions '!$C28, =Value of Expense
TWCF Model'!C$6 = Start of Week Period TWCF Model'!C$7 = End of Week Period
Cheers,
Are all inputs dates, or days of the week (or month)?
Think your issues is because the DAY formula is going to give a number a lot smaller than any DATE it’s being compared to. Dates as a number will be like 40,000+
Quaerat saepe quia ut dolore qui. Nihil nesciunt sit voluptas quo nemo. Quo earum molestiae eum eveniet aut. Veniam neque omnis amet recusandae cupiditate a ut enim.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...