I am looking for a formula in Excel that will always show 4 days from the original due date and is always in the future from today's date.
Let's assume in this example that today's date is 4/4/2018. I would want the formula to let me know that I need to send a letter on the 6th.
<code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; vertical-align: baseline; box-sizing: inherit; white-space: inherit;">Due date Time To Send Letter
3/1/2018 4/6/2018
</code>When we pass 4/6/2018, then the Time To Send Letter cell will show 4/10/2018.
Thanks
Let's assume in this example that today's date is 4/4/2018. I would want the formula to let me know that I need to send a letter on the 6th.
<code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; vertical-align: baseline; box-sizing: inherit; white-space: inherit;">Due date Time To Send Letter
3/1/2018 4/6/2018
</code>When we pass 4/6/2018, then the Time To Send Letter cell will show 4/10/2018.
Thanks