It doesn’t come up very often as I do a lot of work using SQL Server rather than Microsoft Excel, but every so often I do need to do some date manipulation in Excel.
I recently needed to calculate the first and last dates of a year from a user supplied date for a Jet Report. This can easily be done using a combination of the YEAR and DATE functions.
The YEAR function can be used to extract the…
Continue Reading Ian Grieve’s Article on their blog
Excel Snippets: Get First and Last Dates of Calendar Year
It doesn’t come up very often as I do a lot of work using SQL Server rather than Microsoft Excel, but every so often I do need to do some date manipulation in Excel. I recently needed to calculate…
Blog Syndicated with Ian Grieve’s Permission