# emonth how to apply

1. ## emonth how to apply

hi
i have check in and check out date for each guest
i need a formula to calculate how many night each guest stayed in a room for each month. Thant means if i have u guest checking in 01 jul and check out 11 jul then we can easily find that he stayed 10 nights in July, but if i have u guest that checks in on 28 jul and checks our 5 august then i need to calculate how many nights he stayed in july and how many night in august. Any clue any help. Thank you

2. ## Re: emonth how to apply

What you need to understand about dates and times in excel is…

a date is just a number representing the number of days passed since 1/1/900...and then formatted in a way that we recognize as a date. So, for instance, today (Mon 25 Jun 2018) is actually 43276

Time is actually a decimal part of 1 (day), so 06:00 AM is 0.25, 12 noon is 0.5 and 18:00 (or 6 PM) is 0.75

So all you need to do is subtract the "leave" date from the "arrive" date

(also, I think you meant EOMONTH, not EMONTH? And that function calculates what the date will be (would have been) x-months from now (or in the past) )

3. ## Re: emonth how to apply

excel.jpg

can you check the attached pic

4. ## Re: emonth how to apply

Here's one way to do it in one formula. In D2 filled down and across:
Formula:
`Please Login or Register  to view this content.`

 A B C D E 1 Check in Check out total days Days in Jul Days in Aug 2 1-Jul 10-Jul 9 9 0 3 2-Jul 12-Jul 10 10 0 4 3-Jul 9-Jul 6 6 0 5 4-Jul 15-Jul 11 11 0 6 5-Jul 13-Jul 8 8 0 7 25-Jul 3-Aug 9 7 2 8 26-Jul 5-Aug 10 6 4 9 27-Jul 7-Aug 11 5 6 10 28-Jul 5-Aug 8 4 4 11 29-Jul 9-Aug 11 3 8

5. ## Re: emonth how to apply

WELL DONE, and thank you so much, can i have the formula on E?

6. ## Re: emonth how to apply

Did you miss this part?

Here's one way to do it in one formula. In D2 filled down and across:

7. ## Re: emonth how to apply

sorry again, for days in july it is perfect, i need another column of days in august in my case E, so i missed the formula for E
thank you

8. ## Re: emonth how to apply

shmemushi the formula does both columns.

As Jeff reiterated above enter formula in D2 then fill down and across (column E). See what happens.

9. ## Re: emonth how to apply

sorry for my foolish understanding, i was looking for a hard way but it was so easy, didn't get it correctly
Is there any way i can donate some money to you. u saved me plenty of time
Thank you

10. ## Re: emonth how to apply

Thank you for the offer. That's very generous, but this is a free forum.

Glad to help. Thank you for the feedback and rep.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1