Formula to determine date of the Monday preceding a date

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

I need a formula to determine the date of the Monday that precedes a date.

Any help would be appreciated.

Thanks,

Mike
 
Hi Mike!

Try this with the date entered in A1:

=IF(A1-WEEKDAY(A1,3)=A1,A1-WEEKDAY(A1,3)-7,A1-WEEKDAY
(A1,3))

Format the cell as Date

Biff
 
Note: The formula below will return the same date on Mondays. If the
*previous* Monday is desired:

=A1-1-WEEKDAY(A1-1,3)
 
This formula assumes the date is in C5, and will return the preceding Moday.

=IF(WEEKDAY($C$5)=2,$C$5-0,IF(WEEKDAY($C$5)=3,$C$5-1,IF(WEEKDAY($C$5)=4,$C$5
-2,IF(WEEKDAY($C$5)=5,$C$5-3,IF(WEEKDAY($C$5)=6,$C$5-4,IF(WEEKDAY($C$5)=7,$C
$5-5,IF(WEEKDAY($C$5)=0,$C$5-6,0)))))))
 
I need a formula to determine the date of the Monday that precedes a date.

Any help would be appreciated.

Thanks,

Mike
Click to expand...


=A1-WEEKDAY(A1+5)


--ron
 
You must log in or register to reply here.

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

working out a date for a fixed day of the week 4
Determine year over year date for comparison 3
Monday closest to today's date? 6
setting the date to monday 2
Excel Forecasting Dates Out to the Day 3
Comparison of columns using Conditional Formatting 3
Calculate number of Mondays betweeb 2 dates 6
Calculate the first monday of a month in the future or in the past 3

Back
Top