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? |
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? |
=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? |
All times are GMT +1. The time now is 12:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com