Tips and Tricks
- To create a calculation or filtered view based on today’s date use [Today] as the value, e.g. ‘Start Date is greater than or equal to [Today]‘
Useful Links
- The formulas and functions for use in calculated columns (MS web site)
- Forumlas for use in Access query criteria (MS web site)
- Excel 2007 Add-on for WSS to enable 2-way sync between Excel and SharePoint lists – MSDN, June 2007
Plus follow-up – tested with 2010 as well, works with a bit of fiddling about – and download site for the Excel Add-in
PDF of SharePoint formulas – Examples of common SharePoint formulas