Results 1 to 9 of 9

increasing the year in a column

Threaded View

  1. #1
    Registered User
    Join Date
    10-20-2020
    Location
    Brandon, Suffolk, UK
    MS-Off Ver
    mac user. numbers 5.1
    Posts
    6

    increasing the year in a column

    bit of a novice and also on a mac, i hope the xlsx is good.

    this is the local legion membership list, columns J and K show branch and club joining date ( should be same but can differ )

    I want to upload data to epos to give current members 10% off beer ( good hey )

    How do i alter "J" from 11/02/1994 to 11/02/2020

    then column "K" to be expiry date 12 months on 11/02/2021
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Compound interest formula with Increasing interest each year HELP!
    By eugchen in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-19-2020, 05:02 AM
  2. [SOLVED] Order increasing month / year
    By Berna11 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-05-2019, 04:06 PM
  3. =DATE(YEAR, MONTH, DAY) stop month increasing.
    By oneblondebrow in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-01-2016, 09:32 AM
  4. [SOLVED] Sine wave with increasing peaks and increasing troughs
    By JimDandy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-18-2013, 06:28 PM
  5. [SOLVED] Numeration increasing by year
    By pgft in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-03-2013, 04:31 AM
  6. What regular savings, increasing every year to reach goal
    By flossy129 in forum Excel General
    Replies: 0
    Last Post: 06-13-2012, 06:38 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