NEED HELP FOR FOLLOW-UP DATE Formula

[angel0936491749]

"I am conducting research to monitor the depression status of patients. It's crucial that I track their status on a weekly basis. Consequently, I am looking to set up a reminder calendar to facilitate this. I've utilized the provided formula to determine follow-up dates, but Airtable suggests that the outcome isn't recognized as a date format. This has hindered my efforts to create a calendar using the results. I would greatly appreciate any advice on this matter. Thank you!"

  IF(

    {First visit},

    DATETIME_FORMAT(

        DATEADD({First visit},1, 'weeks'),

        'MM/DD/YYYY'

    ),

    ""

)

[Ron_Williams]

DATETIME_FORMAT converts it to a string. Just use 

IF({first visit},DATEADD({first visit},1, 'weeks')) and use the formatting tab in the field to make it look the way you want.