View Single Post
  #1   Report Post  
Pulling My Hair Out!
 
Posts: n/a
Default How do I use the IF function to calculate date

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!