community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Excel Days360 function in Alteryx

Meteor

Hi Everyone,

 

What is the Excel "Days360" Equivalent function in alteryx. I have tried using End day and Start day logics but still not getting the actual result as per the excel.

 

Example Dates:

Start Date                         End Date            Difference as per Excel

02/29/2016                       02/29/2020          1439

07/18/2019                       02/29/2020          221 


Thanks,

Ramn

Pulsar

Hi @RAMN 

 

 

Please take a look at this post for your answer

 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Replicating-the-DAYS360-function-in-ex...

@MarqueeCrew provides exactly what you are looking for.

 

Cheers!

Esther

Labels