Automatically update year + 1

Charles Kenyon · #7 05-04-2020, 07:51 PM

Paul, you are correct.
He started with the wrong formula from DateCalc.
He was using the one for Month and Year but wanted to include the day. That is also found in your work.

Here it is formatted the way he wants it:

Code:

{QUOTE
{SET Delay 1}
{SET od{DATE \@ d}}
{SET oy{DATE \@ yyyy}}
{SET mm{DATE \@ M}}
{SET ld{=(mm=2)*(od=28+((MOD(oy,4)=0)+(MOD(oy,400)=0)-(MOD(oy,100)=0)))}}
{SET yy{=oy+Delay}}
{SET dd{=ld*(28+(mm=2)*((MOD(yy,4)=0)+(MOD(yy,400)=0)-(MOD(yy,100)=0)))+od*(1-ld)}}
"{mm}-{dd}-{yy}" \@ "M/d/yyyy"}

Today, it returns 5/4/2021
This is formatted for US not European date format.
Here is a document containing the field.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to search for a specific year from a table with year range?	Wii	Excel	0	05-05-2015 12:40 PM
How to calculate a rolling year-to-date percentage by quarter as the year progresses	sleake	Excel Programming	2	04-23-2015 11:51 AM
Networkdays per fiscal year in a 6 year range	jabnm	Excel	1	10-16-2014 11:51 AM
Year to Year in Fillable form	Lara	Word	1	04-09-2013 03:19 PM
Creative Ways for a year-to-year comparison???	ridonkulous5	Excel	1	03-23-2011 04:49 PM