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 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