bristolxyz
New Member
- Joined
- Aug 21, 2003
- Messages
- 5
I have an excel sheet that I want to calculate total of invoices that are 31-60, 61-90 and over 90 days old. I can only get the formula to calculate based on what MONTH it currently is. I have a cell that contains a DATE, what I would like to do is be able to put any date in that cell and the formula calculate the results accordingly based on that date. I will follow this post with an attempt to display the sheet here in teh forum...
Regards
Regards