| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
date +7
I have today's date in cell A1. IS there a way to get cell B1 to show the
following week's date? |
|
#2
|
|||
|
|||
|
One way:
Dates in XL are just integer offsets from a base date, so use the + operator: B1: =A1+7 Format B1 as a date. In article , Marlis wrote: I have today's date in cell A1. IS there a way to get cell B1 to show the following week's date? |
|
#3
|
|||
|
|||
|
=A1+7 should do it.
Regards Rowan "Marlis" wrote: I have today's date in cell A1. IS there a way to get cell B1 to show the following week's date? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
| Worksheet Revision Date only once that day | Excel Discussion (Misc queries) | |||
| search for latest date | Excel Worksheet Functions | |||
| Recurring annual events using a specific date as a trigger date | Excel Worksheet Functions | |||
| Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions | |||
Linear Mode
