12/31/2018

So here is what I am looking to do I have a column of dates then a calculated number 1 2 or 3 I have test data and results, I want to calculate the total for the year with an equation but I need the test date to be the latest one so here, 2/10/18 uses 3 then 6/2/18 uses 8 Equation is like this...

H <30 2 >30 A B 12/31/2018 29 12/31/2018 5 My current Formula (adding the days between 0-29)...

Hello There! i am working on a project where i have been given 1200 files and all i have to do is to copy paste the data from 1200 file to 1 file under the given column headers(Headers are the same in 1200 files) i have already written a Macro to resolve this, it works fine in terms of copying...

Hello, I have a line graph with a date range of June 1, 2017 - December 31, 2018. There are no formulas. Each day a number is entered into a cell. From tomorrow through 12/31/2018 the cells are obviously empty. However, the line graph drops to zero and goes all the way to 12/31/2018. How can I...

Hi experts, would like to ask for your favour to create a calender showing recurrence event in monthly basis. i've created the template but i don't know how i can change the formula in tab "Calendar" to show the recurrence. for example, Sports - swimming class, i want to show the same item...