Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
exel"negative and positive days for creditors :formula
I am making a spredsheet that details creditors by date of last payment.I can
create the formula comparing the days from "now" to the next due date and mark it "current" or "attention" if its within 30 days but my problem is that for creditors that are overdue the "dateif"formula will not work as the calculation will not accept going backwards into negative days.Can anyone give me a little guidance as Ive mucked around for far to long. In anticipation Kent |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
exel"negative and positive days for creditors :formula
You can subtract one date from another, and as long as you format the
result cell as Number (with 0 dp) then you should be able to see both positive and negative days. Then use a normal IF on this. Hope this helps. Pete Kent wrote: I am making a spredsheet that details creditors by date of last payment.I can create the formula comparing the days from "now" to the next due date and mark it "current" or "attention" if its within 30 days but my problem is that for creditors that are overdue the "dateif"formula will not work as the calculation will not accept going backwards into negative days.Can anyone give me a little guidance as Ive mucked around for far to long. In anticipation Kent |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell formula where result to be Positive only | Excel Discussion (Misc queries) | |||
formula for negative and positive numbers in different columns | Excel Worksheet Functions | |||
Formula to make Negative Values Positive & Positive Values Negative? | Excel Discussion (Misc queries) | |||
FORMULA TO ADD POSITIVE AND NEGATIVE NUMBERS, REGARDLESS OF SIGN | Excel Discussion (Misc queries) | |||
formula to copy last positive number in range of cells | Excel Worksheet Functions |