Date Values

  • Thread starter Thread starter Alec
  • Start date Start date
A

Alec

I currently have a cell that shows week commencing, ie
Mondays date only for any particular week, I currently
update this cell every week.
I have been looking, unsuccessfully, for a function to
automate this process, any ideas.

Thanks
Alec
 
=TODAY()-WEEKDAY(TODAY())+2

Today where I am is Wednesday, and =WEEKDAY(TODAY()) gives me 4

As long as your system does too, then you should get the same result, otherwise
adjust the 2 as necessary

It also assumes your week starts on Sunday and that on a Sunday you would see
the next days date. If this is OK, or you don't work weekends then this
shouldn't be a problem.
 
Alec,

Here's one idea

=TODAY()-CHOOSE(WEEKDAY(TODAY()),6,0,1,2,3,4,5)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Thank-you Ken.

Bob

Ken Wright said:
Nice :-)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP

-------------------------------------------------------------------------- --
Attitude - A little thing that makes a BIG difference
-------------------------------------------------------------------------- --
Click to expand...
 
Back
Top