10/02/2018

  1. W

    If formula with date plus one.

    Hello Everyone, I'm struggling with a formula and dates Here is the table <tbody> Date Time 10/02/2018 08:00am 10/02/2018 04:00pm </tbody> What I am trying to do is if Time in B2 is greater than 15:00 then date should be A2 date +1 day If Less than 14:59, then use the date in A2.
  2. J

    Total of sum

    Hello, Can somebody help me with this formula I have a excel With a number of columns <tbody> Country Id Title CreationDate </tbody> <colgroup><col><col><col><col></colgroup><tbody> AU 26 F 22/02/2018 DE 190 Et 22/02/2017 DE 242 E 21/02/2018 AU 277 C...

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