days

  1. D

    How to group this in Pivot Tables

    https://1drv.ms/x/s!AvjBsEPEq12ngTpjIV0Ri5AcMKZa?e=0sU8cn I have a table of data. First column = company names. Other columns = invoice amount aging by days E.g. column B = 1 - 010 means invoices overdue between 1 day and 10 days. I am summarizing the info in a PV. Suppose I want to create...
  2. DataBlake

    Loop each sheet between two sheets

    so i'm trying to loop between sheets in between my sheets "Program Start" and "ID check" and if hidden sheets matter it would be between "Program Start" and "Master Image" i.e the loop logic would be: for each sheet between ProgramStart to IDcheck 'do a thing else 'do a thing next sheet the...
  3. J

    Countifs formula across multiple sheets

    I need to compare student IDs on sheets Adds Drops (Column B) to Sheet2 (Column C), and then cross-reference that with the date on both sheets: Adds Drops (Column B) and Sheets2 (Column I). If the dates on Sheets2 (Column I) is more than 7 days later than the date on Adds Drops (Column B) for...
  4. J

    Actual and Budget with different granularity

    Hey, together I'm currently facing a small challenge again.I have the following two tables. TblActuals <tbody> Product ID Group Quantity (Actual) Date A1 A 100 01.01.2019 A2 A 150 02.01.2019 B1 B 50 15.01.2019 B2 B 150 16.01.2019 C1 C 25 08.08.2019 </tbody> TblBudget <tbody>...
  5. R

    30/60/90 days reminders emailed from excel

    Hi, I have a list of c4000 individuals records on a spreadsheet who all hold a qualification that has to be renewed every 3 years. I would like to find an easy way to send reminders directly from the spreadsheet to the individuals concerned with all the details they need to renew in an...
  6. E

    Networkdays formula issues

    Hi Team, Im using formula =NETWORKDAYS to calculate the days but the number are populating incorrectly for different dates. For all it should remain 2? Is there any other formula to correct these issues? <colgroup><col span="2"><col></colgroup><tbody> Date Date Days 29/05/2019 31/05/2019 3...
  7. T

    Insert Pivot Table With Dynamic Lenghtq

    Hi all, I am trying to insert a pivot table into my worksheet however the data can vary in length and I am not sure how to this using the pivot table function, the code I have currently is below. Sub InsertPivotTable()' ' InsertPivotTable Macro ' ' Sheets.Add...
  8. A

    Need to solve a mathematical problem and I must use two fonctions to do it.

    Hi, I need to solve this using 2 fonctions (not 1, not 3). You hire an employee to pick up tomatos.If he picks up 8 cases an hour, 8 hours a day, 6 days a week, but you guarantee him a minimum of 4 weeks, how many days do you hire him for 1000 cases? I'm really stuck with this one and I cant...
  9. K

    Calculation of days in each month..

    Dear Experts, I have a data of planning as mentioned below i want to calculate days of each month from start to end date. Here is my planning chart module and need your assistance in this regard, I have shown example of desire data in last three columns. Best Regard, Kamran Noor <tbody>...
  10. W

    Months and Days Until Next Birthday - 2019 update

    Hi, I was looking for a formula to calculate Months and Days Until Next Birthday. I found this thread https://www.mrexcel.com/forum/excel-questions/355165-months-days-until-next-birthday.html It works well, unless the birthday month and day are the same as today. In that case (e.g. birthday...
  11. Naveed Ul Haq

    Pivot Table Query

    Dear Members, My source data contains Days Column and Hours Column (Clocking In & Clocking Out Columns as well). My Pivot Table requirement is to have Total Hours Worked calculated and total days worked by customer. Can any one of sort it out for me? Regards,
  12. A

    Find Duplicate only if date is within X days of original

    <tbody> B F J ID# Date Duplicate? </tbody> Iwas wondering if you could Help me out with a formula? I need Column “J” tosearch for duplicate values in column “B” and say “Yes” only if the date incolumn “F” is within 180 days (6 months) of the original value.
  13. Y

    Project Workplan Dashboard

    Hi guys, I am very new to VBA and I am looking for some help with some code that would help me at work, basically I am looking to optimize a simple dashboard for my projects Workplan for the year. The table on "2019 Plan" shows the number of projected days and to the right of it the actual...
  14. B

    Calculate number of days excluding Saturdays and Sundays

    Hi All, Would like to ask for your assistance on this if statement.J2 and H2 are 2 different dates. How do I count the difference(remaining days) without including saturdays and sundays? =IF(AND(M2="NA",I2="No"),0,IF(AND(I2="Yes",J2=0),NOW()-H2,J2-H2)) Thank you Bryan
  15. W

    Range of cells

    I have a range of cells d24:g24 that either have a date in them or are blank. I need to put a formula in h24 where the word Alert will appear if any of the dates are less than 180 days from today. Can anyone help?
  16. C

    Days between dates and color coding

    So I have specifation register listing 300 products, the date the specifcation was issued and the date the specification expires. Specifications expire after 3 years. I want to keep my specifcation file current by checking the difference between todays date and the expiration date. If the...
  17. C

    Measure formula to count upcoming days

    Hello there. I found a measure formula to display only dates before today. Is there a way to count only dates occurring in the next 30 days? The first formula was added a measure to a visualization so i suspect I would need to add another measure to the same visualization to show the next 30...
  18. S

    Days between two dates

    Working with an Excel formula. I want the number of days between two dates. I am using 7/1/2018 to 6/30/2019. My formula is =DAYS(B1,A1). Where B1 = 6/30/2019 and A1=7/1/2018. I thought the result would be 365 but I am getting 364. Thoughts?

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top