I am working on a subscription template. I have very minimal experience with formulas in Excel. I want a formula to use a property called "Subscribed Date" formated as MM/DD?YYYY to calcuate the "Next due date" and it be formated as MM/DD/YYYY also. I have the following code that gives me the correct date but in the format of MMM DD, YYYY. I can't figure out what I am doing wrong. I would appreciate any help!
if(formatDate(prop("Subscribed Date"), "MM/DD/YYYY") == formatDate(now(), "MM/DD/YYYY"), "For Today", if(prop("Recurring") == "Monthly", dateAdd(prop("Subscribed Date"), dateBetween(now(), prop("Subscribed Date"), "months") + 1, "months"), if(prop("Recurring") == "Yearly", dateAdd(prop("Subscribed Date"), dateBetween(now(), prop("Subscribed Date"), "years") + 1, "years"), prop("Subscribed Date"))))