Geoff_canada
Board Regular
- Joined
- May 26, 2008
- Messages
- 56
Hello there
I am sure this is a pretty simple problem for all the excel experts out there...unfortunately I am not one of them
I am trying to generate an aging report (ie Current, >30, >60, >90) by referencing a worksheet that has A1:A100 populated with dates.
What I would like to do is count the number of dates in column A and reference current date populate a separate worksheet with a count total of how many fall into current, >30, >60 days etc etc
Not sure I explained it properly but hopefully someone can help.
I am sure this is a pretty simple problem for all the excel experts out there...unfortunately I am not one of them
I am trying to generate an aging report (ie Current, >30, >60, >90) by referencing a worksheet that has A1:A100 populated with dates.
What I would like to do is count the number of dates in column A and reference current date populate a separate worksheet with a count total of how many fall into current, >30, >60 days etc etc
Not sure I explained it properly but hopefully someone can help.