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+
Quis quia nostrum asperiores consequatur consequatur ipsam. Consequatur enim non harum itaque quisquam porro velit. Voluptatem soluta eligendi eaque voluptatibus.
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...