View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default How to calculate a "current week" when it doesn't 'start' on a Sunday or Monday?

Hi,

Am Mon, 21 Sep 2015 10:06:10 -0700 (PDT) schrieb :

A1 is Fri, Sep 18
A2 is Wed, Sep 23
A3 is Mon, Sep 7


please look he
https://onedrive.live.com/redir?resi...=folder%2cxlsm
for "Date Filter"
You have to download the file because macros are disabled in OneDrive.
There are 3 helper cells in the sheet which contains TODAY and the start
and the end of the week. The macro filters the dates from D2 as start to
E2 as end.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional