Hey everyone,

I'm having an issue getting my formulas to display on a Calendar report correctly. The start date is never 'included' in the count of days for the job duration, so on the Calendar I always get an extra day added. I only know that I could add -1 to the formula to minus a day, but then if that value is 0 because it has no duration, it gives me a -1... or if the result is only 1 day for the job, right now it will display 2 days on the calendar, if I add a -1, the duration will change to 0 on my form. Is there any work around to this? Kind of annoying that the start date isn't included in the count.

*Formula:***(ToText(Ceil([1. Sub Duration]/10) & " " & "Days"))**

//

`[1. Sub Duration]`

is my previous step that gets the final number in hours in a

*Numeric - Formula* Field, divided by 10 for 10 hour workdays.

// Then obviously to result in # Days to display on the form for readability.

Any help would be appreciated.

Thanks!

------------------------------

Alex Bennett

------------------------------