Formula for counting days between specific dates

[Stephan Kipper]

Hello everybody,

I would need a little help here. It might be a stupid question, with a very easy solution, but I just can't find it!
All I want to do is to find a formula to count days, between specific dates, but to start counting from a specific date.
For this month a already did that using formula "=end_date-today()".
But for the next month I need it to start counting from 02 March, end date would be 31 March, so for example when the current day is 05 March the cell value should be 26 days, and so on.
Thank you in advance!

 

[bobhc]

You do not say what version of excel you are using, and as things change from one version to another it is all ways a good thing to say.

excel2013, DAYS( end_date, start_date )



https://support.office.com/en-gb/ar...wo-dates-8235e7c9-b430-44ca-9425-46100a162f38

.

 

[Stephan Kipper]

I'm using Excel2007. This ain't the formula I'm looking for. I want it to be dynamic.
Let me put it this way:
I have this cell when I want this date difference/counting.
I have the Start Date 02 March, and End Date 31 March.
Today is 02 Feb , so this value will be static (now I'm using DATEIF formula), because when we will be on 5 March, the value will still be the same.
The formula I'm looking for, I want to automatically calculate how many days are left until the end of the month, but start calculating only when the actual date will pass 02 March.

 

[Chihiro]

Upload sample file representing your set up.

 

[Asheesh]

Hope this helps

IFERROR(1-(TODAY()<=A1)^0,DATEDIF(A1,B1,"d"))

 

[Marc L]

Hi !

Formula in C1 in General format : =B1-A1 and that's all folks ‼ ​

 

[KenU]

Assuming date in cell A1 you could use:

=EOMONTH(INT(A1),0)-INT(A1)

The INT may not be needed, but I don't know whether your dates include the time or not.

Hope that helps.

Regards,
Ken

 

[Stephan Kipper]

Assuming date in cell A1 you could use:

=EOMONTH(INT(A1),0)-INT(A1)

The INT may not be needed, but I don't know whether your dates include the time or not.

Hope that helps.

Regards,
Ken

Thanks. It did worked!