Returning the Beginning of the week

  • Thread starter Thread starter Rizitsu
  • Start date Start date
R

Rizitsu

Returning the beginning of the week.

e.g. if the date == 02/03/04 (Friday 2nd March 2004)

the beginning week for that date == 01/03/04 (Thursday 1st March 2004)

Hows does one go about achieving this?

Regards
 
This formula will take a date in cell A1 and give the start of the wee
in B1

* assumes that monday is the start of the week, so if the date is
sunday in A1, it returns the prior monday

B1 = A1 - (Weekday(A1,vbMonday) - 1
 

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

Week Number Format 4
week entry new 3
calculating compound growth 4
Changing The Day 1
Calculating a week between a range of dates 3
This should be easy - date lookup 9
Lookup part of a cell's contents and return value of entire cell 2
Spreading date range across days in weeks (advanced) 7

Back
Top