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

Recent Posts

See All

Frequently Asked Questions, by phone

I have a warning message When does it happen? Can you send a screenshot to us? Also, if you can, please email the PDF input document to us (or upload it using the 'File' menu within StatementReader) a