+ Reply to Thread
Results 1 to 2 of 2

dragging dates across in table

  1. #1
    Forum Contributor
    Join Date
    09-30-2015
    Location
    LA my baby
    MS-Off Ver
    2013
    Posts
    727

    dragging dates across in table

    Hello I have a table. On the top row I want to copy and paste patterns by pulling the right grid of three months, Jan 15, Feb 15, Mar 15 and it won't do it. I tried changing the format to date to make sure but it's returning all sorts of date patterns that are not what I want. I checked and it's 1/1/2015, 2/1/2015, and so on. Que papa?

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,326

    Re: dragging dates across in table

    Use this, copy across and format as desired:

    =DATE(2016,(COLUMNS($A:A)),1)
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Disable dragging certain fields into the pivot table
    By Sgligori in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-12-2015, 02:50 PM
  2. SUMPRODUCT HELP Dragging formula accross table
    By St3ff3ns in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-24-2015, 05:23 AM
  3. [SOLVED] Dragging the fill handle and keeping table headers locked
    By Butcher1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-04-2014, 10:44 PM
  4. Select Multiple Dates In Report Filter Pivot Table But Dates Are Not Static
    By biasedobserver in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-06-2014, 03:38 PM
  5. Lock Named range from table while dragging formula
    By praveen_khm in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-10-2013, 10:19 AM
  6. [SOLVED] How to set a number of rows for dragging down the table
    By skalus in forum Excel General
    Replies: 6
    Last Post: 04-26-2013, 08:18 AM
  7. Copying dates by dragging
    By aca in forum Excel General
    Replies: 2
    Last Post: 05-12-2008, 07:27 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1