Results 1 to 14 of 14

How to compute date changes for multiple cells in a row

Threaded View

  1. #1
    Registered User
    Join Date
    08-13-2018
    Location
    Georgia (formerly Maryland)
    MS-Off Ver
    home & student 2007 . . . in 2024 (and beyond)
    Posts
    21

    How to compute date changes for multiple cells in a row

    I'm using Excel 2007. I have a worksheet with E3 thru K3 (formatted general) that contain literals 8/11 Sun, 8/12 Mon, 8/13 Tue 8/14 Wed, 8/15 Thu, 8/16 Fri, 8/17 Sat. The 3-character days are always in the same columns. Actually, that row is repeated several rows down for 8/18 Mon thru 8/24. I copy the worksheet every 2 weeks and have to manually change those mm/dd day to different mm/dd. It's tedious, time consuming and error prone.

    Is there a way to automate these changes using formulas, functions or some other "Excel magic"?

    Thus far I've only used 1-digit months and 2-digit days, with leading zero for 1-digit days. Changing the column widths slightly and using 2-digits for both months and days will be fine. Months changing midweek won't be a problem. I can easily handle that manually.

    I prefer changing only 1 row at a time since the row locations may change over time.

    As evidence that I'm brain dead . . . I've tried multiple times to upload a sample, but can't get it to work. I choose a file, but can't upload. I've tried .xlsx and .jpg

    Here's the best I can do 8/11 Sun, 8/12 Mon, 8/13 Tue, 8/14 Wed, 8/15 Thu, 8/16 Fri, 8/17 Sat

    I want 8/18 Sun, 8/19 Mon, 8/20 Tue, 8/21 Wed, 8/22 Thu, 8/23 Fri, 8/24 Sat
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How do I compute end date of each quarter according to the year
    By yipdog in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-27-2020, 05:55 AM
  2. Replies: 4
    Last Post: 03-20-2017, 01:25 AM
  3. [SOLVED] How to compute if a date falls between two specified dates??
    By Swagata in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-12-2012, 07:48 AM
  4. Find and compute multiple values from multiple tables
    By canada123 in forum Excel General
    Replies: 2
    Last Post: 07-18-2011, 09:00 PM
  5. Compute Project Start/End Date
    By COGICPENNY973 in forum Excel General
    Replies: 0
    Last Post: 01-28-2011, 01:15 PM
  6. How to key a formula to compute the due date
    By jamesoc79 in forum Excel General
    Replies: 14
    Last Post: 05-14-2009, 04:41 AM
  7. Replies: 7
    Last Post: 11-16-2008, 05:48 PM

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