I have the following text on sheet TB
Trial Balance : 01/09/13 to 31/08/14
I have the following formula on sheet "Notes"
="Balance "&TEXT(MID(TB!A3,17,8),"DD MMM YYYY")+29
The result of the formula is Balance 41548
It should read Balance as at 30 September 2013 as I want to extract the ef of month date from 01/09/2014 (format dd/mm/yyyy)
Your assistance in resolving this is most appreciated
Trial Balance : 01/09/13 to 31/08/14
I have the following formula on sheet "Notes"
="Balance "&TEXT(MID(TB!A3,17,8),"DD MMM YYYY")+29
The result of the formula is Balance 41548
It should read Balance as at 30 September 2013 as I want to extract the ef of month date from 01/09/2014 (format dd/mm/yyyy)
Your assistance in resolving this is most appreciated