difference in date

  1. P

    DAX PIVOT: Projects Closure Date Field - Number of Days Change - between differing Forecast Versions

    Hi, I'm new to DAX, but I'm sure the solution here should be relatively easy? Any elegant solution gratefully received. I need to be able to report where, between 2 Forecast versions, the Closure date for a Project has slipped (or accelerated). I've used 'Calculated Items' within an ordinary...
  2. P

    IF cell is 0-2 years then 100% IF 2-3 years then 75% and so on....

    Hi, I am having trouble working the logic for the below scenario:- I am aiming to achieve a workbook that will automatically tell me what deduction to make if time between two dates is under 2 years (100%), 2-3 years (75%), 3-4 years (50%) and over 4 years (0%). I have a workbook with a list...
  3. T

    Additional parameters using the WORKDAY.INTL function

    Hello, I am using the following formula to determine a due date (you have 60 days to complete the assignments including weekends and excluding holidays) =WORKDAY.INTL(A1,60,"0000000",C1:C9) A1 = start date 60 = number of day to complete the assignment “0000000” = every day is included (no...
  4. S

    Date and Time for one month for 24 hours in one column

    I have difficulties in date and time format. Since I always need to change the day/month/year. Usually I just did it manually, however after I found this amazing macro things, I hope I can do it using macro which can save me a lot of time. Here the situation is: I have 16 years (1996-2011)...

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