Is there a way to drag down a date like 08/21/11 to get 08/28/11 ? Thanks
J Jim Cone Aug 22, 2011 #2 Enter your start day in C4. Enter this formula in C5... =$C4+7 Fill C5 down. -- Jim Cone Portland, Oregon USA . http://www.mediafire.com/PrimitiveSoftware . (Extras for Excel add-in: convenience built-in) "Gianni" <[email protected]> wrote in message news:[email protected]...
Enter your start day in C4. Enter this formula in C5... =$C4+7 Fill C5 down. -- Jim Cone Portland, Oregon USA . http://www.mediafire.com/PrimitiveSoftware . (Extras for Excel add-in: convenience built-in) "Gianni" <[email protected]> wrote in message news:[email protected]...
G Gianni Aug 22, 2011 #3 Jim said: Enter your start day in C4. Enter this formula in C5... =$C4+7 Fill C5 down. Click to expand... Thank you.
Jim said: Enter your start day in C4. Enter this formula in C5... =$C4+7 Fill C5 down. Click to expand... Thank you.
X XLS S Aug 22, 2011 #4 hey Gianni, use series option press short key Alt + E+ I+ S then step value 7
