Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-04-2016, 12:30 PM
Exhale Exhale is offline Autofill dates - how can I get the same date and consecutive dates? Windows 10 Autofill dates - how can I get the same date and consecutive dates? Office 2010 64bit
Novice
Autofill dates - how can I get the same date and consecutive dates?
 
Join Date: Mar 2016
Posts: 17
Exhale is on a distinguished road
Default Autofill dates - how can I get the same date and consecutive dates?

I hope that this is a simple one for someone to answer!



If I highlight a cell with a date in it and get the black cross in the right hand lower corner, I can extend a series of dates (I'm using the UK system of day - month - year) and it will add a day on for me in each of the next cells. If I needed to have the same date in a few of the next cells and then pick up the date addition again, how can I do this other than by typing manually, each date, please?

I have Windows 10 and Excel version 14.0.7166.5000 (32 bit).

Thanks in anticipation.
Reply With Quote
  #2  
Old 04-04-2016, 09:49 PM
Philb1 Philb1 is offline Autofill dates - how can I get the same date and consecutive dates? Windows 10 Autofill dates - how can I get the same date and consecutive dates? Office 2010 32bit
Advanced Beginner
 
Join Date: Feb 2016
Location: Auckland
Posts: 43
Philb1 is on a distinguished road
Default

To keep the same date press Ctrl when you begin to drag down
Reply With Quote
  #3  
Old 04-05-2016, 12:58 AM
Exhale Exhale is offline Autofill dates - how can I get the same date and consecutive dates? Windows 10 Autofill dates - how can I get the same date and consecutive dates? Office 2010 64bit
Novice
Autofill dates - how can I get the same date and consecutive dates?
 
Join Date: Mar 2016
Posts: 17
Exhale is on a distinguished road
Default

Thanks for your quick reply Philb1 and for the clear instructions. Used it already!
Reply With Quote
  #4  
Old 04-05-2016, 03:11 AM
Philb1 Philb1 is offline Autofill dates - how can I get the same date and consecutive dates? Windows 10 Autofill dates - how can I get the same date and consecutive dates? Office 2010 32bit
Advanced Beginner
 
Join Date: Feb 2016
Location: Auckland
Posts: 43
Philb1 is on a distinguished road
Default

I like easy ones like that
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Autofill dates - how can I get the same date and consecutive dates? Formula or VB to get max date with multiple dates and predecessors? mjank72 Excel 1 07-02-2015 06:20 PM
HELP: Return a value with a date that falls between two other dates hionman Excel 5 11-12-2014 09:56 AM
Date Format: how to output dates that are not US? tinfanide Word VBA 0 10-28-2013 03:30 AM
Default dates for a Date Picker BoringDavid Word VBA 2 09-11-2013 01:42 AM
Creating a consecutive list of dates in a MS word document whenever it is accessed CrabApple Word 11 05-17-2012 03:21 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:26 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft