Excel - Increasing Date Help


Recommended Posts

I have a speadsheet with a weeks worth of dates in each row.

Is there a formula that I can use in the first one so the 6 below will automatically increase their day by 1?

 

So if I put 01.04.21 in the first box, all the others will automatically change to 02.04.21, 03.04.21, 04.04.21...  etc ?

 

I have tried a few but it doesn't seem to work and even highlighting the first date, then dragging down and using the little autofill square (that appears next to the cell) doesn't have a "date" option.

Link to comment
https://www.neowin.net/forum/topic/1406548-excel-increasing-date-help/
Share on other sites

If you express the dates with a / delimiter, the autofill works as you'd expect. It's always handy to start with 2 values as well, select both and THEN drag down. Excel then knows the pattern to follow.

 

image.png.3110ed974001cd550dfd94e3a148af95.png

 

Maybe you could use /, then replace it with . afterwards?

  • Like 1
  • 1 month later...

This is where I lose faith in how "helpful" computers can be.

 

I want the date format to be:  01.01.10

 

But Excel doesn't seem to recognise this as a date format.  The closest would be: 1.1.10.

 

So on one sheet, the cell seems to know it's a date as in the box at the top of the sheet, the date is written as 01/01/2010 but on the sheet, it's translated to 1.1.10.

I've dragged it down and it auto-filled:

 

001.JPG.0e37084801a8dd92a530606dd781e116.JPG

 

The next sheet however, even though the format of the cell is "date" - the same as the sheet before, it won't format the date as a date and won't auto fill:

 

002.JPG.b1cbd07d7bfb57ecc33e1c750d76226c.JPG

 

I really don't understand it.

 

Right, so if I type the date format: 01/01/2010 into the top box, then it reformats it with . in the boxes and I can then drag down.

Shame you can't add the former 0's though.

 

I think what frustrates me is the 15 minutes I've spent trying to make things a little easier, I could have spent manually filling in the dates.

Edited by Sir Topham Hatt

what version of office do you have? I have Office 365 here at work and there are 2 date format options that have the proceeding 0 on my format list

 

image.png.3486d969eaed4f02f86bf027a2b592fb.png

 

 

edit: actually I see the issue, there is FAR fewer selections when you set the locale to UK, try changing it to US to see if you get the option you want

 

image.png.4ec16574e787806c39771d5532b834b9.png

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Posts

    • Microsoft: Windows 11 24H2 is our most reliable version of Windows yet by Usama Jawad A little while ago, Microsoft released a major, but optional, feature update for Windows 11, version 24H2 in the form of KB5062660. It brings agentic search in settings, Recall for customers in the European Economic Area (EEA), new Click to Do actions, and more. Alongside, it also announced some changes to the operating system, powered by the Windows Resiliency Initiative. There are two enhancements in tow for the latest Windows 11 build. The first is Quick Machine Recovery which leverages the always-available Windows Recovery Environment (WinRE) to detect, diagnose, and fix critical issues encountered during boot time. Then, fixes are delivered through Windows Update and applied, reducing the overall downtime and the dependency on IT teams. The idea behind Quick Machine Recovery is to have a system which allows devices encountering boot failures to recover gracefully from their error state with minimal disruption, while also offering granular controls for IT admins. IT personnel have the ability to disable this feature altogether or use it to manage the self-healing mechanism, as well as scan and reboot intervals. The feature is enabled by default in Windows 11 Home, but disabled in Pro, Education, and Enterprise SKUs. IT admins have the ability to enable it through Intune or Policy configuration service provider (CSP). In terms of what's next for Quick Machine Recovery, Microsoft will be focusing on support for Windows Server, more connectivity options, and enhanced IT admins tools. In addition, the latest update to Windows 11 also packs the new BSOD, which should now be referred to as the Black Screen of Death. We have talked about this in detail before, but Microsoft has emphasized that this is more than a simple aesthetic redesign. The new BSOD is made with user experience in mind so that it is less visually disruptive, while still providing critical troubleshooting information (such as a hexcode) in a concise manner. Microsoft says that it has improved crash dump collection in Windows 11, version 24H2 to the point that customers now spend 2 seconds on this screen rather than 40. All of this feeds into Microsoft's narrative that explicitly says that Windows 11, version 24H2 is its most reliable version of Windows yet. It notes that unexpected failure rates which trigger BSOD have dropped by 24%, compared to Windows 11, version 22H2. Interestingly, it has not made a comparison to version 23H2, which suggests that the difference compared to last year is probably negligible - or at least not enough to boast about.
    • Quick Machine Recovery was off by default on my install.
    • GitHub customers rejoice as Command Palette deprecation is delayed by Usama Jawad GitHub Command Palette was announced back in 2021, and has been in preview ever since. For those unaware, this capability allows you to launch a search bar UX through the Ctrl + K shortcut, which offers you suggestions based on your current context. So you can quickly clone repositories, edit pull requests (PRs), and more directly through your keyboard, without navigating through cumbersome nested menus. Almost a week ago, GitHub announced that it is deprecating Command Palette due to low usage and popularity. This led to major backlash from the development community who criticized the move, noting that a preview feature that is disabled by default will obviously have low usage. Many customers cited its usefulness, noting that Command Palette has no alternative that is as powerful, and it's unfair for the company to remove a product due to low adoption, especially since it had not been marketed. Now, GitHub has decided to reverse course on its earlier decision (thanks, The Register) and delayed the deprecation of Command Palette indefinitely. It has updated its previous blog post and shared an identical announcement on a dedicated GitHub thread to indicate that after listening to customer feedback and specialized use-cases, it has realized that its own usage metrics do not reflect the current popularity of Command Palette. It understands that the tool is critical in many workflows and that it needs to re-evaluate its overall approach to navigation. During this period of assessment, GitHub Command Palette will continue to be available, much to the joy of GitHub customers, who have responded very positively to the thread. That said, it is important to note that GitHub's wording is a bit vague, and it doesn't concretely say that Command Palette is here to stay. It's possible that the company re-evaluates its usage metrics sometime in the future and reaches the same conclusion that it did last week.
    • I'd say "no thank you" to Recall. Let's turn it off as quicly as possible when installed. And Microsoft -please- don't let a "bug" re-install/re-configure it again.
    • Let's just wait until Patch Tuesday and have most of the bugs on this KB/download be taken care of & ironed out.
  • Recent Achievements

    • Week One Done
      SmileWorks Dental earned a badge
      Week One Done
    • Community Regular
      vZeroG went up a rank
      Community Regular
    • Collaborator
      Snake Doc earned a badge
      Collaborator
    • Week One Done
      Snake Doc earned a badge
      Week One Done
    • One Month Later
      Johnny Mrkvička earned a badge
      One Month Later
  • Popular Contributors

    1. 1
      +primortal
      589
    2. 2
      Michael Scrip
      199
    3. 3
      ATLien_0
      196
    4. 4
      +FloatingFatMan
      134
    5. 5
      Xenon
      122
  • Tell a friend

    Love Neowin? Tell a friend!