How many days left

[otuatail]

I want to round the value down but is there also a way of rounding the number to the nearest whole number?

=A13-NOW() = 10.67

=ROUNDDOWN(A13-NOW()) This is an error.

TIA
Paul

P.S. all I need to round to nearest is reduce the decimal points to zero.

[Pepe Le Mokko]

Perhaps

Please Login or Register  to view this content.

or easier

Please Login or Register  to view this content.

[tanasedn]

Hi,
What does cell A13 contain?
It is possible to have text in that cell.

[otuatail]

=A13-INT(NOW()) = 11 rounded up

15/12/2022 = Custom (ddd dd-mmm-yyyy) Should get 10 instead of 10.65

=A13-TODAY()
If I move to another cell the forumula changes to
=A13-TODAY() C2

[Pepe Le Mokko]

=A13-INT(NOW()) = 11 rounded up

Why would you want to round up? Does A13 contain something else than a date ( date and time?) ? If so

Please Login or Register  to view this content.

Same goes for the second possibility
If this does not work please post a small sample sheet ( see yellow banner). thx

[JohnTopley]

15/12/2002 - 04/12/2022 = 11 [a13 - today()]

[sandy666]

maybe just use

	B	C	D	E
13	15/12/2022		11	=DATEDIF(TODAY(),B13,"D")

[otuatail]

No that is wrong. Simply put
=A13-NOW() = 10.61 so why= 11?

=DATEDIF(TODAY(),A13,"D") = 11.00 NOT 10

Try it yourself and see if you can get to 10 in cell K2

[tanasedn]

@otuayail
Why you use Now() instead of Today() to count days left?

[otuatail]

No reason but A13-TODAY() is still 11 not 10.

Try it out.

ROUNDDOWN(10.61) = 10 which is what I would expect

[sandy666]

so use

Please Login or Register  to view this content.

and will be 10

-1 because that day (TODAY() ) is not over yet

[otuatail]

That would only work if there are decimal points
10.6 would result in 11-1 = 10
10.0 would result in 10-1 = 9

Do I need to create a macro to check if there are decimals and if so -1 other wise dont subtract anything

Or I could place the 10.61 in a hiden cell and do and do an int into another cell.

That would work.

[tanasedn]

No reason but A13-TODAY() is still 11 not 10.

Try it out.

ROUNDDOWN(10.61) = 10 which is what I would expect

Still not clear for everyone. Why you need to be 10 when the days difference is 11 and is correct? You need to calculate the differences without weekends?

[otuatail]

Okay but why do i get 10.61

Thead closed.

[otuatail]

I was not including today from todat would be 10. Including today qould be 11.

[HansDouwe]

Please try

=INT(A13-NOW()) or ROUNDDOWN(A13-NOW(),0)

Result is 10.

[sandy666]

I was not including today from todat would be 10. Including today qould be 11.

to whom you are talking ?

[popipipo]

That would only work if there are decimal points
10.6 would result in 11-1 = 10
10.0 would result in 10-1 = 9

If you use Today() you never get any decimal points