Yesterday I had this requirement to add number of months (m) to a cell that contains start date to estimate the end date. In 2003 I had to use a complex formula like below where A1 is the cell that contians the start date.
=DATE(YEAR(A1),MONTH(A1)+m,DAY(A1))
Well in Excel 2007 it is even more easy to add months with the Edate function like below.
=Edate(A1, m).
Subscribe to:
Post Comments (Atom)
-
From the past 3 days I have been working on resolving merged and hidden cells issues when an SSRS reports is exported to excel. ... -
When I tried to access the report manager after a fresh installation of Sql Server Reporting Serivces 2016 using the url http://localhost/R... -
I was trying to build an SSIS package that one of my colleagues has created. The first error that was thrown was as below: Exception des...
No comments:
Post a Comment