Excel date formula question

[zblaff]

Hello,

I'm trying to compare a date to that same date plus 30 days (for payment purposes) and return a message, and i've not been able to do it. I'm using this formula: =if(today()>d2+30, "delayed", "ok")

(D2 is where i have my date). What am i doing wrong here? I'm using MS Office 365

Thank you in advance for your help

 

[MARK858]

Can you define what is wrong for you as it works fine for me (maybe also state what the formula =ISNUMBER(D2) returns)

Excel Workbook
	A	B	C	D
1	delayed
2	ok			01/09/2018
3				01/10/2018
Sheet2

 

[RoryA]

Your formula is saying is today's date more than 30 days after the date in D2 - is that what you meant?

 

[zblaff]

I've done it like that, the only difference being that the cell i'm trying to insert the formula into is the J2. If you could show me where i can do a table like the one you posted in your answer i can show your better.

Thank you

 

[zblaff]

Yes, that's what i mean. If I received an invoice at 1/01/2018 i want to see a message that tells me when 30 days have passed from the day i received the invoice

Thank you

 

[RoryA]

You haven't said what the actual problem is. What is your formula returning?

 

[zblaff]

https://i.gyazo.com/2165d643455f881fa6fe619b146199d0.png

Basically it says there is a problem with this function

 

[zblaff]

	A	B	C	D	E
1	xxx	xxx	xxx	01/01/2018	=if(today()>d2+30, "delayed", "ok")
2

<tbody>
</tbody>

 

[RoryA]

Do you normally use semicolons in formulas like this:

=if(today()>d2+30; "delayed"; "ok")

I note that the formula selected in that image has nothing to do with this question.

 

[zblaff]

Thank you, it's better now, but still not perfect

I've changed it to semicolons and now it appears the #NAME ? message