# Re: Problems with static dd/mm and rolling year

joeu2004
Guest
Posts: n/a

 17th Aug 2012
"JoAsh" <(E-Mail Removed)> wrote:
> Im currently trying to create a database for work to flag up documents
> which are due for review each year. The IF statements are all working
> for this system but the one thing which is creating problems is that I
> cant seem to find the correct formula to show the review date (Which is
> an annual static dd/mm each year) but have the year part automatically
> rolling over to the current year.

When you ask questions like this, you need to give us some details to work
if you want a turnkey solution. Cell references; cell contents. How you
determine the review year. How you determine dd and mm: in cells;
hardcoded?

If the last review year is a number in A1, perhaps =DATE(A1+1,3,15) will
work to specify a next review date of March 15 one year later.

Alternatively, if you just want "next year", perhaps
=DATE(YEAR(TODAY()),3,15).

with some details.

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post Frank Kabel Microsoft Excel Misc 3 8th Jun 2005 11:21 PM =?Utf-8?B?d2F0IHByaW4=?= Microsoft Excel Worksheet Functions 0 28th Jan 2005 04:43 PM =?Utf-8?B?QWw=?= Microsoft Excel Programming 3 14th May 2004 12:51 AM Chris2 Microsoft Access Queries 6 25th Mar 2004 09:21 PM =?Utf-8?B?SmFuZXR0ZSBSb2JpbnNvbg==?= Microsoft Access 2 27th Nov 2003 06:07 PM

Features