dte

I'm relativity new to VBA. I am hopeful someone can help me with the below macro. The Macro takes a day of the week like Monday or Tuesday and converts it to a real date based on whats imputed. It works the way I want other than, I need it to be formatted as a 2 digit month 2 digit day and 4...

I have a worksheet that has almost 500,000 lines of data. I want to sum up all the data for each day. My dates are stored in the format dd/mm/yyyy and are in column M, my values to be summed up are in column H... and my output should show in column N... My code so far doesn't seem to work...

I'm a complete novice at this, but have stumbled through up until this hiccup. Trying to create code to check each cell in a column and if there is data in the cell, convert the data to a US date (currently coming in as text and European format). I got the date code to work in a different macro...

Hi, Im writing some code to calculate daily, monthly and annual realised volatlity. ( I know i can do this with stdev but for what i want to use it for i want a manual calc.) I keep getting "subscript out of range" error once it goes beyond my last cell in the monthly calcluation Any ideas...