7 January 2013

First client

31 December 2019

Last software update

< 2 hours

Support response

StatementReader is used by forensic accountants, bookkeepers, insolvency investigators, solicitors, auditors and business review professionals to stop wasting time and talent converting bank statements into Excel

This website uses cookies to enhance the user experience.  Click here for our cookie statement and here for our privacy policy.

All Rights Reserved 2012-2020 Suave Software Limited. London, England, United Kingdom. Email Us

  • LinkedIn Social Icon
  • Twitter Social Icon

Date adjustments using DATE


Changing dates across many lines of transactions can be tiresome. To ensure that this process is fast and accurate, you should use the DATE formula.

=DATE ( year , month , day )

Using this format you can use certain parts of the date that has been extracted from the bank statements, quickly replacing, for example, the year, with 2014. To achieve this example, use the following format, replacing XXX with a cell reference to the extracted date:

=DATE ( 2014 , month(XXX) , day(XXX) )

#Excel #Formula #All