Using EOMONTH to stop a formula on the 1st Day of the next month.

I am using a spreadsheet to calculate the number of bed nights our residents have in a month. I keep a running total if the guests are current (No Exit Date) but at the end of the month I need the tally to stop as it is a monthly report.

=IF(Entry_Date="","",IF(Exit_Date="",DATEDIF(Entry_Date,TODAY(),"d"),Exit_Date-Entry_Date))

This is what I have entered and it works perfectly until I get to the end of the month and there are residents current. I need the Bed Nights to stop calculating at the first day of the next month Is there a way to add in a EOMONTH part to this formula?

Thank You. This formula does not include the last night of the month as a bed night also. What would be the formula to include the last night?

Hmmm still does not give me the last night of the month included

Thank you for your response. I need to now replace the Entry_Date with the first day of the month. What is the correct way to write this formula?

=IF(A6="","",IF(L6="",MIN(TODAY(),EOMONTH(A6,0))-A6+1,L6-DATE(2016,1,1)))

A6 is entry_date, L6 is exit_date. I want my monthly register of guests to calculate the bed nights of each guest for the current month only. If the guest checked in on the previous month I do not want those bed nights of the previous month to be counted, only the current month. I need the bed nights to keep a running total (of only the current month) At the end of the month the bed nights stop adding up after counting the last night of the month.

The formula above works except is it calculating the bed nights to the end of the entry_date month instead of the current month of the worksheet.. How do I rewrite this?