lol... let me try that without getting timed out...
What I need is for the following:
Based on two cells (call them A1 and B1) which will have a year (ie 2009) and a month (either as a number like '5' for May or just the word 'May')
I need something that will, in a cell in row 3 (call it 'A3'), put '01/05/09' there, but in proper excel date format so that calculations in the same column as this pasted date can be done (they will be calculations such as if(S19=<A3,then do this, otherwise do this) and so on.
Once I've got that, I can just fill the rest of the row with (cell to the left +1)
If someone could be really clever though, It'd be good to be able to in row 2: have what day of the week that date is
And if it stops autofilling the row with dates at the end of the month, that'd be great (so when it's a 30day month like June, the last column doesn't come up with 01/07/09)
PS - I cannot install any additional Controls like Calendars (don't even have the standard one built in which is weird)
Tried the =TEXT options, but they couldn't return the values as date format, so subsequent calculations would never work because it's trying to ask if the text "01/05/09" is equal or less than the (number)date"01/05/09" - so of course it returns an error.
So basically, depending on what month and year you select in A1 and B1, to fill row 3 with all the dates for that calendar month.