What date is 7 days before today?
Find out which date was 7 days before now. When was today minus 7 days. The calculator adds or subtracts days, weeks, months and years from now.
Today is October 30, 2024.
7 days before today was:
Wednesday, October 23, 2024
54th day of of autumn, 297th day of the year.
Leap year. 69 days until the end of the year.
Born at the year of 🐲 Dragon according to Chinese Zodiac calendar, and under ♎ Libra sign according to Western Zodiac calendar.
Wednesday, October 23, 2024 as Unix timestamp: 1729670290
7 days in other units of measurement is
- 604,800 seconds
- 7 minutes
- 7 hours
- 1 week
How to subtract 7 days from a date in Excel or Google Sheets?
This is a super easy thing to do in Excel. Click on a free cell and create a new formula. First select a reference to a cell with date or use TODAY() function for current date. Then add {{number}} days as a plain number. Make sure that target cell format is set to "Date".
=TODAY() - 7Replace TODAY() with a cell reference (for example: A1) to manipulate dates other than today's date.
If you want learn more about using Excel or Google Sheets formulas to add or subtract days, weeks, months or years from a date click here. You can also download a free Microsoft Excel sample spreadsheet with examples.
People also search
- What date is 100 days from today?
- What date is 60 days from today?
- What date is 90 days from today?
- What date is 80 days from today?
- What date is 62 days from today?
- What date is 56 days from today?
- What date is 45 days from today?
- What date is 40 days from today?
- What date is 36 days from today?
- What date is 28 days from today?
- What date is 21 days from today?
- What date is 7 days from today?
Last updated : July 26, 2024