LinkBack URL
About LinkBacks
If you want to avoid Analysis ToolPak dependency (pre XL2007) you can:
(above assumes per profile 1st of month at all times)
=DATE(YEAR(A1),MONTH(A1)+B1,1)
If you want to avoid Analysis ToolPak dependency (pre XL2007) you can:
(above assumes per profile 1st of month at all times)=DATE(YEAR(A1),MONTH(A1)+B1,1)
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks