• Instructions to Ask a Question

    Click on the "Ask a Question" button and select the application for which you would like to ask questions.

    We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.

    The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!

    🚀🚀Exclusive Discount Offer

    Just in case you're looking for any ongoing offers on Pabbly, you can check the one-time offers listed below. You just need to pay once and use the application forever -
     

    🔥 Pabbly Connect One Time Plan for $249 (🏆Lifetime Access) -  View offer 

    🔥 Pabbly Subscription Billing One Time Plan for $249 (🏆Lifetime Access) - View offer

Calculating Age

thms

Member
Hi,
I'd like to calculate the age within a workflow, based on a value gathered in a previous step (Step 5 in formula below). Could you help me figure out why the result always ends up in "0"?
I'm using the Number Formatter > Spreadsheet Formulas action.


ROUNDDOWN((MINUS(2023-05-23,5. Data 2 Value : 1990-05-28))/365,0)
 

ArshilAhmad

Moderator
Staff member
Hey @thms,

Please share your workflow with us at the provided email address so that we can gain a better understanding of your concern.
Email: [email protected]
Also, remember to revoke access once your query has been resolved.

Attaching a video for your reference:

 
Top