Determine year over year date for comparison

's Computer Specifications

Hello, I am trying to determine the date of the same Monday last year based
on the date of the latest Monday's date.

If I just subtract 364 from the current date, I can get the date; however, I
think that this formula would create errors if there is a leap year.

Thank you,
Brian

's Computer Specifications

Hi,

Try this

=IF(WEEKDAY(A1-364)=2,A1-364,A1-365)

Mike

"zeroscou" wrote:

> Hello, I am trying to determine the date of the same Monday last year based
> on the date of the latest Monday's date.
>
> If I just subtract 364 from the current date, I can get the date; however, I
> think that this formula would create errors if there is a leap year.
>
> Thank you,
> Brian

's Computer Specifications

Thank you Mike, that works and is nice and simple.

"Mike H" wrote:

> Hi,
>
> Try this
>
> =IF(WEEKDAY(A1-364)=2,A1-364,A1-365)
>
> Mike
>
> "zeroscou" wrote:
>
> > Hello, I am trying to determine the date of the same Monday last year based
> > on the date of the latest Monday's date.
> >
> > If I just subtract 364 from the current date, I can get the date; however, I
> > think that this formula would create errors if there is a leap year.
> >
> > Thank you,
> > Brian

's Computer Specifications

Glad I could help

"zeroscou" wrote:

> Thank you Mike, that works and is nice and simple.
>
> "Mike H" wrote:
>
> > Hi,
> >
> > Try this
> >
> > =IF(WEEKDAY(A1-364)=2,A1-364,A1-365)
> >
> > Mike
> >
> > "zeroscou" wrote:
> >
> > > Hello, I am trying to determine the date of the same Monday last year based
> > > on the date of the latest Monday's date.
> > >
> > > If I just subtract 364 from the current date, I can get the date; however, I
> > > think that this formula would create errors if there is a leap year.
> > >
> > > Thank you,
> > > Brian

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Help with year to date comparison	danny	Microsoft Excel Worksheet Functions	4	10th Sep 2009 08:13 PM
Determine the months remaining from date to the end of the year	Tim Cameron	Microsoft Excel Misc	4	11th Jan 2008 01:33 PM
How to determine if year is a leap year	=?Utf-8?B?V2FuZGE=?=	Microsoft Excel Worksheet Functions	7	17th Sep 2007 07:48 AM
Determine Which Half of Year Based on Date	=?Utf-8?B?aGNhbXBiZWxsMTk2Ng==?=	Microsoft Access Queries	1	31st Aug 2006 11:37 PM
Determine the date for the Friday of a given Year and week Number	\DoctorV3774 via AccessMonster.com\	Microsoft Access Reports	2	9th Jul 2005 05:18 PM