needing formula to calculate fulfillment needed per day


Board Regular
May 31, 2012
I'm a photographer needing help with determining how many images to edit per day in order to meet a deadline. The columns are as follows:

D) Status - The status column indicates where the client currently sits in the workflow, such as "Scheduled", "Edit", "Reveal", etc.
F) Due Date - The Due Date column specifies the date promised. Some clients provide due dates if they need their images prior to their bday, anniversaries, etc. If blank, my goal is to edit 40 images within 14 days.
K) Session Date - The Session Date indicates the date of the photoshoot.

My goal is to edit 40 images per client while meeting either a 14 day deadline, or the client's specified deadline. Obviously if I had two photoshoots the same day, I would need to edit twice as many images per day. But it gets a little confusing when I shoot a client on let's say a Monday, and the next client the same week on a Thursday, therefore the formula would need to take other columns into consideration. I could upload a sample spreadsheet if that helps, it's been a while since I've posted here and can't remember the perferred site for hosting uploads.

Some videos you may like

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Watch MrExcel Video

Forum statistics

Latest member

This Week's Hot Topics