I have today's date in cell A1. IS there a way to get cell B1 to show the following week's date?
M Marlis Aug 17, 2005 #1 I have today's date in cell A1. IS there a way to get cell B1 to show the following week's date?
J JE McGimpsey Aug 17, 2005 #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.
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.
