Multiple Date calculations and formulas - so lost!

[jae113]

Hello Again,

Ok, this is a few steps. I want in my sheet, to have a column of items, we'll call them dogs, with today's date, the date the dogs were born, and a column that calculates how long the dogs have been alive.

Based on the "alive" number, I need to calculate the kennel fees for 30 days at one price ($4 a day) and additional days at another price ($6.50 a day).

THEN I need to include another set of fees, also based on 30 or >30, this time being the first 30 days there is a flat fee of $2000, and then again at 91 days another $2000 charge.

FINALLY - I need to add all the fees together!

To say that I'm rusty on Excel is an amazing understatement! I realize that these are all pretty simple formulas, but I'm having trouble reasoning them out. Any and all help would be greatly appreciated!

Jenna

 

[barry houdini]

If the dog's DOB is in A2 then you can get the dog's age in days by just subtracting the DOB from today's date, i.e.

=TODAY()-A2

Assume that formula is in B2, format B2 as general

Now to get the total daily fees you could use this formula in C2

=B2*6.5-MIN(30,B2)*(6.5-4)

and then finally for the specific fees

=IF(B2>=30,2000,IF(B2>=91,4000,0))

Then just add the last two for the total