Calculate the dates for a specific month where multiple In and Out dates are present

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?
 

Some videos you may like

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

Watch MrExcel Video

Forum statistics

Threads
1,099,113
Messages
5,466,755
Members
406,497
Latest member
Bryanlim

This Week's Hot Topics

Top