Determine year over year date for comparison

Z

zeroscou

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create dates for year, allow for leap year 8
Year End totals 7
Allocate an income payment over a date range (tax years) 7
Countif year = help needed 2
Using a Date and corresponding weekday to pull amounts 1
Search closest day in the past from today 2
Value of the first day of a year in a list 5
Finding the current year 3

Top