Calculate Day count given different duration dates

[Miss A!]

Hello there - Please help......

 

 

I would like to create a field(Day_Count) that determines the day number(in red font) of a Trip/Visit record. Given the following records for the trip identified as 14CHACAP00214:

PLACE                      DATE_IN                DATE_OUT                NIGHTS          DAY_Count

Safari Camp            Date in: 11.03.2014 Date Out: 13.03.2014 Nights: 2       DAY 1

Cost Dunes             Date in: 13.03.2014 Date Out: 13.03.2014 Nights: 0       DAY 3

Mokuti Lodge          Date in: 13.03.2014 Date Out: 14.03.2014 Nights: 1       DAY 3

Gross Barmen         Date in: 14.03.2014 Date Out: 18.03.2014 Nights: 4       DAY 4

 

How do i implement a calculation for this result - or what solution will work for this scenario?

 

Many thanx for all suggestions/opinions,

Miss A!

 

 

 

[comment]

Is there a StartDate field in the parent record?

[Miss A!]

Yes there is a date When the trip starts and a date when the trip ends.

[comment]

Well, then subtract the StartDate of the parent trip from the DateIn of the itinerary item (?) and add 1.

Edited May 28, 2015 by comment

[Miss A!]

Yes Yes Thank you - got idea from your first suggestion, was not trusting what i made of it simply because just(most times i do not know what am doing).