What date is 1 week before tomorrow?
Find out which date was 1 week before tomorrow. When was tomorrow minus 1 week. The calculator adds or subtracts days, weeks, months and years from now.
Today is October 22, 2024.
1 week before tomorrow was:
Wednesday, October 16, 2024
47th day of of autumn, 290th day of the year.
Leap year. 76 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 16, 2024 as Unix timestamp: 1729122739
1 week in other units of measurement is
- 604,800 seconds
- 7 minutes
- 7 hours
- 7 days
How to subtract 1 week from a date in Excel or Google Sheets?
There is no specific function for adding or subtracting weeks in neither Excel or Google Sheets. But you can use an easy formula for days with "x7" multiplier:
=TODAY() - (1 * 7)Replace 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