Update field B to be 365 days after field A
I know this is supposed to be really easy, but I can't figure it out. I have field A that will be populated with a date. I want/need field B to automatically populate with 365 after the date in field A. I know there is the .addDay() function, but I don't understand how I'm supposed to format my custom function to get it to return 365 days after the date entered in field A. Please help. I know this is supposedly really easy, but I'm having a hard time, so a detailed explanation would be really appreciated.