date adjust

  1. D

    get dates from a range in ascending order

    On another sheet, I have dates in column A. In the new sheet, I need to first extract the earliest date from column A of that other sheet which is easy. just use the "Min" function for A column. So now the earliest date get picked and feeds into the cell of the new sheet in D1. How do I get the...
  2. A

    Help converting a date with a timestamp in excel

    Hello! In my office we use slack for the majority of our communication needs. With Slack you can build workflows that allow users to enter data which can then be imported into an excel sheet. Slack date/timestamps each submission in the excel file in a format which looks like this...
  3. A

    Unique Problem of Inputting date across all cells with value

    Hi I have a unique problem. I have multiple csv files and I need that the date value (ddmmyyyy format) mentioned in B3 column to be printed from D5 onwards in D column across all cell where a value is mentioned in C column. I shall merge all these csv files into one xlsx file through VB code and...
  4. B

    Adjust holiday (Xmas) break in between the project.

    Hi Everyone, I will be great-full if someone can help me with the formula or macro on this. We have tasks assigned to each department with the due date. The tasks have been distributed in the order that they need to be completed. This is done so that each department completes the tasks in...

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