Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I change this to count days
I recieved help yesterday on my "IF" problem but I forgot the fact that if a
pymt is paid a month later it isn't calculating. Here is what I got yesterday for a fix late fee; =IF(OR(B7="",DAY(B7)=27),43.75,0) Column A has date pymt due Column B has date pymt paid Column F has the late fee Here is what a friend and I came up with for a per day late fee =IF((B18-A18)=5,E18*0.05+(B18-A18-5)*E18*0.01,0) The problem is again is that I need both formulas to reconize complete dates. Example, Column A - Date payment is due is 3-22-08 Column B - Date payment is made is 5-20-08 Thank you for your time and assistance. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I change this to count days
Make it easy. If you want to find number of days late, then do:
=(If(payment date - due date)0,(payment date - due date)*per-day charge,0) Sounds like maybe you charge different late fees based on length of time late? If so, just add that as a nested if. "H Halliburton" wrote: I recieved help yesterday on my "IF" problem but I forgot the fact that if a pymt is paid a month later it isn't calculating. Here is what I got yesterday for a fix late fee; =IF(OR(B7="",DAY(B7)=27),43.75,0) Column A has date pymt due Column B has date pymt paid Column F has the late fee Here is what a friend and I came up with for a per day late fee =IF((B18-A18)=5,E18*0.05+(B18-A18-5)*E18*0.01,0) The problem is again is that I need both formulas to reconize complete dates. Example, Column A - Date payment is due is 3-22-08 Column B - Date payment is made is 5-20-08 Thank you for your time and assistance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Days more than 180 days prior to today | Excel Worksheet Functions | |||
When word says Install I want it count the days for 3 days w.o wee | Excel Worksheet Functions | |||
How to change the default of 30 days change history | Excel Discussion (Misc queries) | |||
Re Change 5 week days to 7 days in this formula | Excel Worksheet Functions | |||
COUNT how many ROWS ago out of 10 days that the highest high in 10 days was made | Excel Worksheet Functions |