Daily Collections Formula

Hi I need a formula for a daily cash flow model.

1. Collection of daily sales

Sales on Monday are collected on Wednesday

Sales on Tuesday are collected on Thursday

Sales on Wednesday are collected on Friday

Thursday Friday and Saturday sales are collected on Monday

Sunday sales are collected on Tuesday

However, when there’s a federal holiday sales will be collected the following day provided that day is not a weekend day (Saturday and Sunday). I need a formula to take into account these exceptions. See attachment for an example. I would also like to be able to set collection days as a variable see cell T22 for an example. (where I could change collection days and the formula would reflect the changes) see cells W23- W29.

Beceriler: Muhasebe, Excel, Finans, Intuit QuickBooks , Bordro

Daha fazlasını gör: cash flow accounting, accounting see, COLLECTIONS, accounting set, excel 2013 formula, accounting cash, sales model excel, need formula, accounting model, accounting cash flow, daily sales excel, daily account inventory system, daily collections, cash flow excel, collections account, excel cash flow, daily sales, project daily account, daily cash flow excel, collections excel, 1k yahoo daily account creation, site free daily account, variable excel, example accounting excel, test email account receiving attachment

İşveren Hakkında:
( 5 değerlendirme ) `Washington, United States

Proje NO: #4396289



Hi, Simple one. I can do this formula and give it to you by tonight. I have 8 years of experience in programming. I can make sure whenever the values in the collection days changes the formula will change and the ca Daha Fazla

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD
(1 Yorum)