Date functions in Excel 2007 tables

[rövitt]

How can I use the various date functions in an Excel table generated by MS
query, without having to convert the table to a range, thereby losing the
query definition ?

 

[ShaneDevenshire]

Hi,

You can place any calculated field in columns directly adjacent to the
connected table range and then you can have Excel fill those formulas down
automatically everytime you refresh your data.
1. Create a formula in the column direcly adjactent to the table.
2. Click in the table range and choose the command Data, Import External
Data, Data Range Properties. Turn on the bottom checkbox - Fill down
formulas in columns adjacent to data.

Hope this helps.