Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I am creating a statement form. I need it to take the date of each item on
the statement and calculate whether that item is less than 30 days, 31-60 days pastdue, 61-90 days past due, and finally over 90 days past due. Depending on the out come of the value, I would like the amount of each item placed into the appropriate box (current, 1-30 days past due, etc...) Wow, upon reading the above, I think I've managed to confuse my self! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel | |||
Calculate age as of a given date | Excel Discussion (Misc queries) | |||
Calculate age as of a date certain | Excel Discussion (Misc queries) | |||
Problem with Date format from VBA code | Excel Discussion (Misc queries) | |||
How do I run an Excel function only once? | Excel Discussion (Misc queries) |