Thread: Help required on Tabulating monthly expenses for the Current Month,Previous Month and Month previous to that
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default Help required on Tabulating monthly expenses for the Current Month, Previous Month and Month previous to that
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
Reply With QuoteReply With Quote