3/1/2018

Dear Team, I do not accurately know how to calculate months and days between two dates. I am not even sure what sort of assumptions that I should make. If I have these dates: StartDate EndDate 3/28/2017 3/1/2018 3/29/2017 3/1/2018 3/30/2017 3/1/2018 3/31/2017 3/1/2018 1/2/2019 9/25/2019...

Can anyone point me in the right direction to create a bubble chart out of the data below that shows each product as the same color, the date along the x-axis, the affinity index on the y-axis, and the avg basket $ as the bubble size? I've been searching, but can't find an example of what I'm...

Hi All, <colgroup><col width="58" span="3" style="width:43pt"> </colgroup><tbody> Date Month Value 1/1/2018 Jan 2 2/1/2018 Jan 4 3/1/2018 Jan 8 1/1/2018 Jan 1 2/1/2018 Jan 3 3/1/2018 Jan 5 1/1/2018 Jan 7...

Hello! The data shown below has been sorted ascending by Case Number then by Last Modified Date to create an ordered record set for each case number. I need to get the next closest date/time in Last Modified Date to Row 1 of that same column for each ordered record set and return a “Null” if a...

I have a Power Pivot column called "Timeliness" that has values such as After 2/1/2018, Before 2/1/2018, After 3/1/2018, Before 3/1/2018. How do I create a IF statement that counts the rows for all the one's that are for After? The Excel formula would be like =COUNTIFS($A$1:$A$5,"After*")...

Hello Excel Gurus, I'm trying to write a code that will transform my data from singular columns to multiple rows. My data is currently organized like this; <tbody> Index Budget View 1/1/2018 2/1/2018 3/1/2018 4/1/2018 123 Budget $10.00 $10.00 $10.00 $10.00 123 Forecast $10.00 $0.00 $5.00...

I want to find the value in A1 in column F and return the corresponding date in column E in cell A2 as shown below. I am trying to avoid creating a lookup table and vlookup to do it. Column E and F have duplicates so I just need the date upon the first match of the value. <colgroup><col...