0

How can I count days in the reporting period?

Jet Reports Historic Posts

October 12, 2010 17:17

None

Follow

Hello,

My report has a date criteria entered by the user ( ex. all data between 01/01/2010..12/31/2010) . I would like to be able to have a count of how many days are in the reporting period. How can I count days between "date1" and "date2"?? can this be done?

K

• Facebook
• Twitter
• LinkedIn

1 comment

• 
  Jet Reports Historic Posts October 13, 2010 18:10 Official comment

  Hi K,
  
  In Excel, you can just do a subtraction of the 2 dates and it will give you the number of days. So if 1/1/2010 is in cell C2 and 12/31/2010 is in cell C3, you could do this:
  
  =C3-C2
  
  In this case, this will give you 364. Does that help?
  
  Regards,
  Hughes