wednesdays

  1. B

    How Many Wednesdays in a Month Where Weeknum is OddNum

    Trying to figure out the formula for this. Type the following in column A: Jan 2018 Feb 2018 Mar 2018 ... In column B, the formula will calculate how many Wednesdays there are in that Month where Weeknum is an odd number. Most months have 2, but a few will have 3.
  2. A

    How to count the number of wednesdays in the next month given the date of the last wednesday of the previous month

    Hello everyone! Okay im super new to excel vba so I apologise if my question is really basic:P I've been asked to automate the sheet below but have no idea how to go about it. So the data values in the table are linked to a PHD system that generates the data using the dates at the top of each...
  3. J

    Formatting dates

    I use the following code to populate a date field on a sheet right now ws.Range("E7").Value = Format(DateSerial(CInt(Left(raceDate, 4)), CInt(Mid(raceDate, 5, 2)), CInt(Right(raceDate, 2))), "Long Date") raceDate is a string...so for example if its value was "20141101" the output I'd get would...

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