28th

  1. L

    Navigating to Worksheet

    Hello, I have my first sheet 'Switchboard' that has this formula in Cell E1: =WEEKNUM(TODAY(),2) This yields '28' for the 28th week of the year. My worksheets are labeled Week 1, Week 2, etc. Since this is the 28th week of the year is there a way to jump to that worksheet (Week 28) ...
    • Legacy 436357
    • Thread
    • 28th labeled week worksheet year
    • Replies: 7
    • Forum: Excel Questions
  2. L

    Calculate 28th of month with exception

    Hi I’m looking for one formula to calculate the day a payment is made. Let me explain. I have a date in A1 which could be any day in the month and in A2 onwards I need to show the 28th day of the month following the date in A1 or the previous working day if the 28th is a weekend. For example...
  3. A

    Return value to a weekday closest to certain date

    Hi, I’m trying to return salary (from one cell) in to a cell next to the 28th (calendar as list) or Friday prior to the 28th if the 28th falls on weekend or bank holiday. Any help greatly appreciated. Thanks
  4. D

    MS Outlook email macro multiple Excel attachments to 1 recipient

    Hi, I have been struggling with this and would be grateful for any suggestions. I have an email macro which runs down a list of recipients in column B and attaches a specified file in column C (saved to my desktop). This operates fine however the recipients have asked for one email with...

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