date field

  1. B

    Pivot Table Help: MMM YY

    I currently have a column of data that is formatted as "MM/DD/YYYY 0:00". I have been formatting it to "MMM YY" by using the formula "=text(cell, "MMM YY"). This accomplishes my task, but them the columns are sorted in ABC order instead of date order since it is a text and not a date field. I...
  2. P

    Week Num and using Dynamic Dates

    I have a Week Ending Date Ranges that follow every Sunday. My report has a box the user enters the Week Ending they want to see, then the report will populate the next 7 week endings to view report. So if the user enters week ending 3/17/12, the report will populate the next 7 weeks, I simply...

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