weeknumber

Hi team, I am building a custom ribbon UI Workbook. I am using this (see below) to get Today's Date. Function mydate() mydate = Date End Function + Sub DATE(control As IRibbonControl, ByRef label) label = "" & mydate & "" End Sub Then I am using this (see below) to get Today's Weekday...

Hi I am trying to get pivot table to show me sales data for a particular store for a each week number of the year. I have my main data in the below format Date Month Week No Day MMM-DD Warehouse Store Sales Values 30/12/2019 Dec 1 30 Dec-30 West Shop 1 20 31/12/2019 Dec 1 31 Dec-31 West...

Hi, My week 1 starts from August 27th 2017 which would be classed as AW17 (Autumn/Winter). My week 27 starts from February 25th 2018 which would be classed as SS18 (Spring/Summer). I need a piece of code that would pull the 17 or 18 from current work calendar.. if I use Format(Now(), "yy")...

Hello, Is it possible to get Fridays date of Week Number 38,39,40 and So on.. THnaks, Prasaad Gaikwad. <tbody> </tbody><colgroup><col></colgroup>

Hello All, I'm using a UDF to get from a yyyyww notation to a real date. I take the yyyy value from a cell, use it in ISOYEARSTART and then add 7 times the number of weeks from the same cell =IFERROR(IF(A3=0;"";ISOYEARSTART(LEFT(A3;4))+7*RIGHT(A3;2))+5;"") I add 5 days, to end up on a friday...