Alvinpereira
New Member
- Joined
- Apr 28, 2015
- Messages
- 19
Hi Team,
Is there a formula which can get the total number of days between multiple entry and exit days in the same month.
I have 6 columns in total and 3 of those are Entry dates and the other 3 are exit dates. Its not mandatory that the entry dates are to be filled nor the exit dates. SO if the entry date is not mentioned or is the entry date is of a earlier or later month then the Month ( we are calc for) start date must be considered and if the Exit date is not mentioned or is of a different month then the month( we are calc for) end date must be taken into consideration.
Can some one help me please?
Is there a formula which can get the total number of days between multiple entry and exit days in the same month.
I have 6 columns in total and 3 of those are Entry dates and the other 3 are exit dates. Its not mandatory that the entry dates are to be filled nor the exit dates. SO if the entry date is not mentioned or is the entry date is of a earlier or later month then the Month ( we are calc for) start date must be considered and if the Exit date is not mentioned or is of a different month then the month( we are calc for) end date must be taken into consideration.
Can some one help me please?
