Hi there,
I am trying to create a column within my workbook that will calculate the age of a date column then output the undernoted categories:
1 - 2 Month
2- 3 months
3 - 4 months
4 - 5 months
5 - 6 months
< 6months
I can programme this in SAS but can seem to workout the syntax for the formula in Excel 2010. Can anyone help with this, I was using an IF statement with a Today() function but couldn't get the output like the above, it would only give me a number.
Many thanks
Bookmarks