#1   Report Post  
Old February 23rd 19, 09:06 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2019
Posts: 1
Default Anniversary dates

I've been trying to use a formula that will auto-populate the next anniversary date for an employee.

The formula I am using will get the correct year, but not the month and day right. Here's what I am using:

=edate(E3,(datedif(E3,TODAY(),"y")+1)*12)

Here's a link to the spreadsheet if you'd care to take a look.

https://docs.google.com/spreadsheets...it?usp=sharing

Any suggestions are appreciated!

  #4   Report Post  
Old February 25th 19, 02:58 PM posted to microsoft.public.excel.misc
dpb dpb is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2018
Posts: 67
Default Anniversary dates

On 2/24/2019 10:01 AM, dpb wrote:
....

=DATE(YEAR(TODAY())+N(DATE(YEAR(TODAY()),MONTH(A1) ,DAY(A1))=TODAY()),MONTH(A1),DAY(A1)))


is off-the-cuff recast...untested.* Particularly check for matching
parentheses.


And indeed, the logic test is reversed in the above..


=DATE(YEAR(TODAY())+N(DATE(YEAR(TODAY()),MONTH(A1) ,DAY(A1))TODAY()),MONTH(A1),DAY(A1)))


--



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
1st, 5th, 10th, 15th Anniversary dates for employees base on Hire Jugglertwo Excel Discussion (Misc queries) 3 July 19th 09 12:32 AM
Conditional Formatting Function for Anniversary Dates blucajun Excel Worksheet Functions 5 June 12th 08 09:06 AM
anniversary dates Vicki Excel Discussion (Misc queries) 4 September 25th 07 06:14 PM
Date range selection? Anniversary dates mrburnette Excel Worksheet Functions 6 August 30th 07 07:16 PM
recurring anniversary dates Blackhawk Excel Discussion (Misc queries) 0 August 2nd 05 06:21 AM


All times are GMT +1. The time now is 11:44 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017