Blue triangle in Numbers indicates “Duration units were removed”

Question

Blue triangle in Numbers indicates “Duration units were removed”

After converting an excel spreadsheet to numbers, I received several blue triangles. I was able to clear almost all of them with one Clear All ‘click’ (on my iPad). But I am left with two that will not give me this option. The formula that was entered is (365x2)-(Today-B5) *note: Today and cell are in oval circles. The formula is designed to calculate the number of days remaining (Today) before hitting the 2-year mark (365x2) after the date opening a credit card (B5 cell). What correction can I make to remove the blue triangle? Thanks to all in advance.

iPad Pro, iPadOS 17

Posted on Sep 15, 2024 10:59 AM

Reply

Answer 1

Top-ranking reply

SGIII

Level 8

37,550 points

Sep 15, 2024 5:47 PM in response to facingthelake1188

The result of TODAY-B5 will be Duration since you are subtracting a Date & Time from a Date & Time.

If you want that result to be decimal days (a number) that can be subtract from another number (365*2) then consider using the DUR2DAYS function.

=365*2-DUR2DAYS(TODAY-B5)

More on DUR2DAYS here:

DUR2DAYS - Apple Support

SG

Reply

Answer 2

SGIII

Level 8

37,550 points

Sep 16, 2024 4:10 PM in response to facingthelake1188

Screenshot?

If you are pasting it in directly from the forum here rather than entering it yourself, then you probably need parentheses after TODAY.

=365*2-DUR2DAYS(TODAY()-B5)

In the formula editor it will then display as TODAY.

SG

Reply

Answer 3

Sep 16, 2024 4:06 PM in response to SGIII

I used this formula/function…

=365*2-DUR2DAYS(TODAY-B5)

Reply

Answer 4

Sep 16, 2024 11:26 AM in response to SGIII

Unfortunately I am getting a syntax error using this formula.

Reply

Answer 5

SGIII

Level 8

37,550 points

Sep 16, 2024 3:59 PM in response to facingthelake1188

facingthelake1188 wrote:

using this formula.

Exactly what formula?

Can you post a screenshot of it?

SG

Reply

Answer 6

Sep 16, 2024 5:06 PM in response to facingthelake1188

THANK YOU VERY MUCH!!! I kept trying different variations of your suggested formula/function. This is what finally worked…see the formula line below the table.

Reply

Answer 7

SGIII

Level 8

37,550 points

Sep 16, 2024 6:47 PM in response to facingthelake1188

Great to see that it has worked on your end!

SG

Reply

Blue triangle in Numbers indicates “Duration units were removed”

Similar questions