Daily Collections Formula

$30-250 USD

En curso

Publicado

hace alrededor de 11 años

$30-250 USD

Pagado a la entrega

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.

ID del proyecto: 4396289

Información sobre el proyecto

1 propuesta

Proyecto remoto

Activo hace 11 años

¿Buscas ganar dinero?

Dirección de email

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto

Cobra por tu trabajo

Describe tu propuesta

Es gratis registrarse y presentar ofertas en los trabajos

Adjudicado a:

@sasindiv

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 calculations will be handled.

$110 USD en 1 día