View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Francine Otterson
 
Posts: n/a
Default Function Help - Counting Days

Thanks for the response. I would like to know based on calendars if a ticket
has been opened greater then 60 days and count those occurrences.

"Barb Reinhardt" wrote:

Do you just want to know how long the ticket has been opened? Do you want
calendar days or working days?

"Francine Otterson" wrote:

Good Day,

Need assistance please on the best method to do the following

Based on dates in column E (date ticket was open) I need to count the
following occurrences indicating since the date was open it has been 1 day,
7 days, 30 days and 60 days.


Any assistance appreciated.