day value

  1. D

    Adding a name to specific time slots within an Excel spreadsheet

    I work in Advertising Sales and when I send clients their daily logs in excel, some need to have day parts added to the corresponding time slots. An example of this is: Date Scheduled Time Aired Program Name 7/4/2016 6:48:08 AM Early Morning 7/4/2016 6:50:08 AM Early Morning 7/4/2016...
  2. A

    value of the day in the year

    I can do that if i write date in a cell it tell me its(dates) value in the year, Example: if i write 14-Feb-15 it tell me 45th day of the year. if i write 1-Jan-15 it tell me in second cell first day of the year.

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