+ Reply to Thread
Results 1 to 2 of 2

Anniversary Date Formula Reminder [Google Sheets]

  1. #1
    Registered User
    Join Date
    06-14-2014
    Location
    Birmingham, USA
    MS-Off Ver
    Office 365 Version 2202
    Posts
    59

    Anniversary Date Formula Reminder [Google Sheets]

    Hi guys, back for some more help that I believe will wrap up my workbook I have been using since starting up a few months ago. I am having trouble staying on top of a anniversary type system we use in which every 4 months a raise is due. Unless anyone has any better ideas, I was thinking of adding a column to show when their next anniversary is, and when their last one was. And maybe some sort of conditional formatting to show that it was within this past week the persons anniversary just occurred. Only problem is this is on google sheets.


    So what I need is:


    Column A - This is the hardcoded name of the individual
    Column B - This is his original start date he started working
    Column C - This is is the date his next 4 month anniversary is due
    Column D - This is the date his last 4 month anniversary was (in case I missed it)

    **Would like for Column D to display red or something if his last anniversary was within the past week or something.

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,945

    Re: Anniversary Date Formula Reminder [Google Sheets]

    In C2:

    =EDATE(B2,INT(DATEDIF(B2,TODAY(),"m")/4)*4+4)

    In D2:

    =EDATE(B2,INT(DATEDIF(B2,TODAY(),"m")/4)*4)

    Format C2:D2 for dates, and use CF for D2 with the formula option, using a formula like

    =AND(D2 *greater than symbol * =TODAY()-7,D2 *Less than symbol* TODAY())


    (For some reason, I cannot post with a greater than or less than symbol in a formula!!!!)
    Bernie Deitrick
    Excel MVP 2000-2010

+ 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. email row contents based on cell values (google sheets populated by google forms)
    By reedg in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 01-13-2016, 02:55 PM
  2. Help need Formula to calculate vacation days left based on anniversary date.
    By yreynolds in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-25-2015, 11:57 AM
  3. SUMIF with different date formats (Google Sheets)
    By djarcadian in forum Excel General
    Replies: 1
    Last Post: 08-09-2014, 08:16 PM
  4. Birthday and work anniversary reminder from excel file to outlook email
    By paulbochniak in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-03-2014, 09:21 PM
  5. [SOLVED] Formula assistance needed to sum data based on anniversary date and month date
    By lilsnoop in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-28-2012, 11:18 PM
  6. Formula for Vacation Accrual Days Based on Anniversary Date
    By Mustang03 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-23-2010, 09:34 PM
  7. Anniversary Date Recognition Formula Help?
    By onflight1978 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-08-2010, 02:00 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