Need a Fancy Formula (;

[Caroline_Chavez]

I have been perusing the community forum and topics trying for hours to create a new date in a field for 6 days out by using a different date field as the base number. For example, I have a field named ‘Lead Mag Date’ where the date is input manually. I would like another field named ‘Day 6 Call’ to automatically populate the correct date for 6 days later. (i.e., Lead Mag Date 7/14/2020; Day 6 Call 7/19/2020.

Here is the formula I was trying to create:
DATETIME_DIFF({Lead Mag Date}TODAY(),‘days’) + 6, {DAY 6 CALL} = ‘MM/DD/YYYY’)

Any suggestions? Thank you for your help. It is much appreciated.

[ScottWorld]

Welcome to the community, @Caroline_Chavez!

You’ll want to use the DATEADD function like this:

DATEADD({Lead Mag Date}, 6, 'days')

Hope this helps! If this answers your question, could you please mark this comment as the solution to your question? This will help other people who have a similar question. :slightly_smiling_face:

[Caroline_Chavez · Accepted solution]

Thank you for your quick feedback. Here is what I ended up using and it worked:

DATETIME_FORMAT((DATEADD({Lead Mag Date}, 5, 'days')), 'L')