3/1/2019

Hello, Used the following formula but the results I'm getting is not what I'm expecting. =DATEDIF(A1,B1,"m")+DAY(B1)/(32-DAY(B1-DAY(B1)+32))-DAY(A1)/(32-DAY(A1-DAY(A1)+32)) For example: Cell A1: 3/30/2018 Cell B1: 3/1/2019 The number of months missing should be 12, but I'm getting 10.06...

I was looking for some help with a formula. I want to count the number of months between two dates and have them be separated by the year. I received a formula but all it did was count the months and put them in the last year column. The formula that I am using is below. It works in my...

Look up date and return the cell and the prior two columns (three columns total) Data field: <tbody> 1/1/2019 2/1/2019 3/1/2019 10 10 10 </tbody> Summary: <tbody> 3/1/2019 30 (formula) </tbody> Thank you

Hello, I would really appreciate some help please What I want to do is search for A2 in column F:F and for B2 to be >= in G:G. So, 2 variables. Then, if these two variables are met I want to substact the 5 items that are required in C2, from H2 and H3 (5 items in total) and show somehow where...

Thanks in advance for any suggestions. I will provide feedback. What function would be able to obtain the date from Row 1 for the first 0 or blank in Rows 2, 3, and 4 but based on dates equal to or greater than the respective cell in Column A. Manually obtaining them, it would be as follows...

So, I want to create a Pivot table that displays DELIVERY DATE, sum of RUN#, sum of ORDER#, sum of ORDER AMOUNT, calculates RUN TIME (using DISPATCH TIME & RETURN TIME) in one or two Pivot Table(s). I am having a tough time figuring it out. Data sample is below that I import into a table from...

Hi, what kind of chart would you use to plot the following data. date client quantity user for example: 3/1/2019 Client1 50 Kristen 3/1/2019 client2 35 Kristen 3/1/2019 Client1 55 Bob i'd love to be able to filter by date, client, user == see how many widgets Kristen did for client1...

How do you update a date to current yr. I have a column with 3/1/2018, with the next 5/15/2018 and I need them updated to to 2019. Meaning 3/1/2019, and 5/15/2019