Hello Forum,
I have web query criteria which works ok from the 10th of any month, but will not work before the 10th of any month.
In the sample provided, Row 35 is criteria from a raw data source prior to the web query.
Cell Range 51 is the "converted" the web query date and code requirements.
But I cannot seem to get the Day Of Week it's leading zero ,01,02,03,04,05,06 etc.
On all other days it works fine from the 10th onwards.
I have tried Text formats, but they don't seem to work either.
Excel version is 2003
Is this a formula error,can it be fixed please ?
Much appreciated.
Regards
Mix