30th

Hi I have a spreadsheet which has many tabs at the bottom for different companies. Sheet1 is the master where all info is recorded on a daily basis, I run the macro and it copies the data to the relevant company tab, all that is ok. Now I have been asked that a new page is created with just the...

Hello all, I have a user form which the date is selected from 3 different dropdown boxes (month, day, year)... Those values are then entered into my sheet in C3:5. My problem is that someone could in theory plan something for "June 31st" or February 30th" for example. Is there an effective...

I have written a formula that looks in up to 31 tabs (designed to fit a monthly schedule) looking for values. Problem is, by the time I get to the 30th and 31st... the formula is way too long. I can always truncate the formula and put a second portion elsewhere but I would prefer to keep it...

Hi I have data in column F that contains the time and date for the month April 2016. I would like to sort the data so that data that contains the 1st is sorted to F1:F999, 2nd F100:F1999, 3rd F2000:F2999 .... and so for the rest of the month so that the 30th would be F30000:f30999. Is this...