excel basic formula

  1. T

    Date /Time Conversion help

    Ok, this is a strange way to format ime...2010-05-16T23:59:59. I need some help pulling out the date so it formats in a normalized dd//mm/yyyy. for example, =MID(Q4,FIND("-",Q4)+1,2) gets the day value. I need to concat the different values into a regular date. Suggestions?
  2. A

    Adding a fixed value to a range of cells

    Hi, I'm working with a column of library fines in a spreadsheet and I'd like to add .50 (cents) to each cell automatically every week (apparently this is currently being done manually). So I'd like a formula that will add .5 to the range of cells and replace their current value. I'm guessing...

Watch MrExcel Video

This Week's Hot Topics

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
Top