custom date

  1. R

    Custom week number / Custom Fiscal year

    Hello, I am trying to create a custom week number formula where week starts on Saturday and ends Friday. The fiscal year starts from 02/01/2018 and ends on 01/31/2019 ** This how i want week number list to start and end. The three columns, first column shows week number, second showing...
  2. C

    Custom Date Range

    I need the range of days in a table (where a single month has been selected ) to return the 14th of the prior month through month end of the selected month. I am using the BasicCalendarUS table from the Azure Marketplace as my date table for reference if it aids in a solution. Any help is...
  3. T

    m/d/yyyy date format not working with VBA, but does manuall?

    Hi I have to convert a serial date into this specific format "m/d/yyyy" for an entire column. When I do it manually through Excel Format Cells / Custom and create "m/d/yyyy" is works. When I write VBA code to convert it, it doesn't work? Columns("L:L").Select Selection.NumberFormat =...

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