Thread: Help required on Tabulating monthly expenses for the Current Month,Previous Month and Month previous to that
View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
San[_4_] San[_4_] is offline
external usenet poster
  
Posts: 26
Default Help required on Tabulating monthly expenses for the CurrentMonth, Previous Month and Month previous to that
On Monday, August 11, 2014 11:49:10 AM UTC+5:30, Claus Busch wrote:
Hi,



Am Sun, 10 Aug 2014 18:45:10 -0700 (PDT) schrieb San:



BTW if I need to trap the expenses week-wise say for the current week, Week[-1] and Week[-2] I can use the WEEKNUM(Today(),2), WEEKNUM(Today(),2)-1 and WEEKNUM(Today(),2)-2 for getting the same. But again I face the same problem when the Current week is the 1st week of January.



try:

=WEEKNUM(TODAY(),2)

=WEEKNUM(TODAY()-7,2)

=WEEKNUM(TODAY()-14,2)







Regards

Claus B.

--

Vista Ultimate / Windows7

Office 2007 Ultimate / 2010 Professional

Great!.. I should have thought in that line. Thanks
Reply With QuoteReply With Quote