Calendar Days count between two date fields

[#1]

Dear Experties ,

I have a one query regarding Calendar days & working days  count between Two dates. As i count clendar days & working Days between ENDate - STARTDATE then i will get days , but if the  start date and end date would same date it will gives us 0   instead of 0 i want to show as  1 day so how would  do i  acheive it  . Please see the screen shot below as i expecting days are highlithed in red.

It would be helpful  if anyone can provide the logic.

[PrashantSangle · Accepted solution]

Hi,

write if condition like

if(startdate=enddate,1,yourexpression)

Regards,

Prashant