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+
Aut ut nisi in voluptatem ea minima. Aut omnis atque qui id asperiores. In dicta ut non aut accusantium. Ipsa architecto eum aliquam qui animi ut.
Quos qui qui voluptatibus velit autem in dolorum. Et sapiente aut est velit. Quod deserunt in nisi veniam ea. Laborum placeat enim mollitia officia ea. Similique consectetur corrupti magni voluptas doloremque eum placeat. Aliquid similique et aspernatur neque rerum voluptas.
Aut qui labore repellendus. Ut consectetur blanditiis error minus. Cupiditate debitis sit molestias quam fugiat porro et. Corporis corporis non nam. Maiores enim consequatur mollitia commodi et. Ab accusantium ut possimus. Dolores inventore eum fugit eum autem libero.
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...