1/1/19

If I am using =DATEIF(B3,C3,"M") how can I add 1 to the sum of the formula? I am trying to create a lease calculator and I need to include the first day of the lease in the formula. If I have a date range of 1/1/19 to 3/11/19 it currently gives me 2 and I need it to read 3 in this case.

Hi All, I have a column with employee names (A1:A5), and to the right of these names are the days that they have requested off (B1:F5). <tbody> A B C D E F 1 John 1/1/19 5/2/19 2 Mark 3/6/19 10/10/19 3 Barry 22/5/19 31/12/19 15/4/19 17/8/19 3/8/19 4 Kevin 6/6/19 5 Clare...

I swear this has to be easy but I'm not figuring this out. I've looked at VLOOKUP, Index & Match, Pivot Tables, etc. I've got a table with 65k rows. In one column, I have a customerID, in another column I have an item purchased. I have many other columns, but I want to be able to find...

Hello everyone, I am a long time lurker and excel novice. I have a data set that has multiple entries per date and per group and I would like to combine those entries into a single line. I have given an before and after example below. I am hoping for a VBA solution so that I can save it as a...

I'm trying to could the number of days between a set of days. Example: 1/1/19 - 12/31/19. I need to could the days between 6/1 & 11/31 and never mind the year. If the dates are 1/1/19 to 12/31/20 then I need it to count them.

Hello, I am building a worksheet that I will need to get data from. The question is how can I write a code so that it can pull data by date. For Example on the main Sheet A--------B-----------C 1/1/19 - Job1234 - COMPLETE 1/1/19 - Job5678 - Not Complete 2/1/19 - Job9012 - COMPLETE 2/1/19 -...

Good day all, I am not great with date/time things in excel. I have one column that is a text column that gives time intervals in seconds. I have a separate cell that gives a start time/date. What I want to do is create another column that adds the seconds to the initial start time/date, so...

Hello, I have sheet one that has all the calendar dates and spaces. Sample Sheet a <tbody> WA WA1 WA2 WA3 WA4 1/1/2019 1/2/2019 1/3/2019 1/4/2019 </tbody><colgroup><col><col span="5"></colgroup> Sheet 2 has the locations with the dates they are booked...