Excel: Date between two dates Solved

Question

Hello,  I would like to know if a date falls between two others disregarding the days (thus only considering the months and years). I created a formula that works with days, but since the statistics are calculated by month, it is therefore not usable:  =IF(AND(present>F2;present

Mike-31 · Accepted Answer

Hello,

the date in C1, this formula will give you the difference between that date and the first day of the month, you need to format the cell to standard

=C1-EOMONTH(C1;-1)

--
See you +
Mike-31

A period of failure is a perfect time to sow the seeds of knowledge.

Vaucluse · Answer

Hello
we don't understand your problem
if F2 start date and H2 end date correspond to the 1st day of the start month and the last day of the end month.. where is your question?
best regards

--
Let’s ask ourselves if we are alone in understanding what is being explained?

gladou67 · Answer

These are start and end dates of contracts but they are not month start and end dates. An employee can start on April 14 and end on October 5.

I would like that when I enter an end of month date in the "present" cell
it tells me how many days this person worked this month.

However, if I enter the date May 30 for the person who started working on April 14, it will calculate the difference between May 30 and April 14. Is there not a way to only count the days of the month entered in the "present" box (in which case it would tell me 30 days and not 30 + the days of April).

I admit that the wording I used earlier was ambiguous and I apologize for that.

Pitu · Answer

Hello,

If what you want is just a yes/no type of answer, I propose this:

=IF(AND(MONTH(present)>=MONTH(startDate);MONTH(present)<MONTH(endDate)+1);"YES";"NO")

ex:
start date = 01/02/2012
end date = 15/04/2012

present = 15/01/2012 => NO
present = 01/02/2012 => YES
present = 23/02/2012 => YES
present = 15/04/2012 => YES
present = 28/04/2012 => YES
present = 01/05/2012 => NO

Is this what you want?

--

(:*Þ Pitù

No way, nor even close

gladou67 · Answer

Thank you for the formulas. I made a small table with the start and end dates, and what I would like is clearer.

Since I couldn't find a way to include a file, I’m providing a link to download it for free.

http://dl.free.fr/getfile.pl?file=/jki4k90d

eriiic · Answer

Good evening,

Your request in the file does not match your request from the 1st post (???)

For your request from the 1st post:
=AND(YEAR(TODAY())*100+MONTH(TODAY())>=YEAR(B4)*100+MONTH(B4), YEAR(TODAY())*100+MONTH(TODAY())<=YEAR(C4)*100+MONTH(C4))
to be copied down

Returns TRUE/FALSE, you can add a test if you want a different response.

Eric

gladou67 · Answer

Indeed, the formula works and correctly shows if the agent was present in the month! Thank you very much. However, I don't understand the formula (especially the *100 part, in fact).

gladou67 · Answer

Alright, that avoids the conversion to "real date format," the one that counts from 01/01/1900. Thanks for the tip. And how can we count the worked days like in the example?

Excel: Date between two dates

8 réponses

Access issue to my "contact me" profile

Windows spotlight is not working.

Total av has charged my bank account.

Personalized e-ticket purchased on viagogo?

Cheats for gta san andreas on xbox 360

Samsung j5 unable to answer

My nikon coolpix s3000 won't turn on anymore.

Bug with the "backspace" key

Do you know maillotsofficiels.fr?

Wii balance board issues