Subtracting Dates Macro Issue

[ScabbyDog]

I have the below code that subtracts a date that I type into B3 (the cell is formatted dd/mm/yyyy) from the date in cell B1 which is todays date. If I have tomorrows date in B3 the result returned is 0 when it should be 1. Why is this?

Please Login or Register  to view this content.

[Norie]

Now returns the date and time.

The formula returns 0.19943044 for me, which is about 4 ¾ hours.

Have you've formatted the cell with the formula so that decimals won't show.

[ScabbyDog]

I have X3 formatted to Number with 0 decimal places. So the above macro returns 0 in X3. Answer should be 1 when taking tomorrows date from todays though......

[Norie]

The answer isn't 1 though, you are subtracting a date from a date/time, so you will be left with a time portion.

[ScabbyDog]

Ah I see what you mean. So is there a formula I can use in cell B1 that will just display todays date?

[Norie]

Use TODAY().