shg
MrExcel MVP
- Joined
- May 7, 2008
- Messages
- 21,836
- Office Version
- 2010
- Platform
- Windows
The closing curly braces in the post at http://www.mrexcel.com/forum/excel-...ar-service-open-enrollment-jan-1-jul-1-a.html are rendering as pairs of asterisks:
B2: =-HLOOKUP(-EDATE(A2, 12), -DATE(YEAR(A2) + {2,1,1**, {1,7,1**, 1), 1)
Anybody know why that is?
EDIT: Here also.
B2: =-HLOOKUP(-EDATE(A2, 12), -DATE(YEAR(A2) + {2,1,1**, {1,7,1**, 1), 1)
Anybody know why that is?
EDIT: Here also.
Last edited: