nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

Set Return Date as today +5

hi there,

i have a form to manage my graphic designer's projects. It includes a To Graphics date and Return to You date. How do I set the Return to You date to be today +5 or greater?

Find more posts tagged with

Forms

Calendar View

Formulas

Comments

Mike Wilday

You can't really set the return date to =Today(5) because every time the sheet is opened the current date would shift... The Today() formula always updates today to be the most current date every time the sheet is opened it recalculates the date for today.

I would create an Assigned Date column that you put the current date in and then have the Due Date column calculate the assigned date plus 5 days.

=[Calculated Column Name]@row + 5

or if you want working days,

=Workdays([Calculated Column Name]@row, 5)

Sign in to join the conversation!

Quick Links

Trending discussions

Display Attachment Names in a Column
Hi everyone, Is there a way to display the attachment name(s) in a column?
Checkbox if a multi selection drop down is used
I am currently trying to check a box if there are multiple options selected from a drop-down menu. The goal is to check the box if it has more than one workstream selected from the drop-down menu. There are multiple options that can be selected which are listed below. Servicing Transformation Production Transformation…
HOW TO USE IF BLANK WITH THIS FORMULA
I am using this formula to return the month and year from a reference date, but cannot figure out how to use IFBLANK with it in order to return a blank cell if the reference date cell is empty. This is the formula I am using and trying to add IFBLANK to. =IF(MONTH([WALL DESIGN FINISH (ACTUAL)]@row) = 1, "01-",…