If Statement Then Output Custom Text

[Stuznet]

Hi guys,

I'm having little trouble writing an IF statement. 

Here is the logic DateReceived minus Inv Date being greater or less than 50. 

This is the the function I wrote but is invalid. 

Column = IF (AND(('Table1 '[DateReceived]) - [InvDate] < 51 ),  "<50 Days","50+ Days ")

Can someone please help?

[Anonymous]

@Stuznet

The formula you have is invalide because you are using AND condition and only condition1 is listed. Here is how I fix it:

Column = IF ( DATEDIFF(
                      [InvDate], [DateReceived], Day) <50
                      ,"<50 Days"
                      ,"50+ Days ")

[Anonymous · Accepted solution]

Hi @Stuznet

Use this.

Column = IF ( Table1[DateReceived] - Table1[InvDate] < 51 , "<50 Days","50+ Days ")

Thanks

Raj

[Stuznet]

@Anonymousperfect as always. 🙂 

[Anonymous]

Thank you @Stuznet 🙂