'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Calculate a Date Seven Days from Today in Microsoft Lists
Question details
The user needs to create a calculated column in Microsoft Lists or SharePoint that automatically calculates and displays a date exactly seven days after the current date.
- Product
- Microsoft Lists
- Device & OS
- not provided
- Scenario
- Setting up a calculated date column to track upcoming deadlines, follow-ups, or weekly reminders based on the current date.
- Observed behavior
- The user requires the correct formula syntax using the TODAY function to ensure the calculated column outputs the future date accurately.
Ensure you have the necessary List or Site permissions ('Design' or 'Full Control') to create or modify calculated columns within your Microsoft List or SharePoint library.
Use the TODAY Function in a Calculated Column
Apply a simple mathematical addition to the TODAY function to calculate a date 7 days in the future.
In Microsoft Lists and SharePoint, date calculations can be performed by simply adding or subtracting the number of days directly from a date function. The TODAY function dynamically retrieves the current date, making it perfect for generating rolling deadlines.
Open your Microsoft List or SharePoint list, click on the Gear icon (Settings) in the top right corner, and select 'List settings'.
Scroll down to the Columns section and click on 'Create column'.
Enter a name for your column (e.g., 'Follow-up Date') and select 'Calculated (calculation based on other columns)' as the column type.
In the Formula box, type exactly `=TODAY()+7`. Ensure there are no extra spaces.
Under 'The data type returned from this formula is', select 'Date and Time', choose 'Date Only', and click OK to save your column.
Need a powerful spreadsheet tool for complex formulas?
While Microsoft Lists handles list tracking online, for advanced data analysis and complex date formulas, WPS Office provides a fully featured, lightweight, and free desktop alternative to Microsoft Excel.
- 1. Download and Install: Get WPS Office for free from the official website and install it on your device.
- 2. Open WPS Spreadsheet: Launch the application and create a new blank spreadsheet.
- 3. Test the Date Formula: Click any cell and type =TODAY()+7 to instantly calculate the date exactly one week from today.
Frequently Asked Questions
Does the TODAY function in Microsoft Lists update automatically every day?
No. In Microsoft Lists and SharePoint calculated columns, the TODAY function is only evaluated when the item is created or modified. If you do not edit the item, the calculated date will remain static based on the date it was last modified.
Can I subtract days instead of adding them?
Yes, you can easily find a past date by replacing the plus sign with a minus sign. For example, use =TODAY()-7 to return a date exactly seven days prior to the current date.
How do I add months instead of days?
Adding months is slightly more complex than adding days. You will need to use the DATE function combined with YEAR, MONTH, and DAY functions. For example, to add exactly one month, use: =DATE(YEAR(TODAY()), MONTH(TODAY())+1, DAY(TODAY())).
Why is my formula returning an error?
Syntax errors in calculated columns usually happen due to missing equals signs, typos in the function name, or incorrect regional separators. Double-check that your formula is typed exactly as =TODAY()+7 and that you selected 'Date and Time' as the return type.
