top of page

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) )

Recent Posts

See All

Improving Excel with Python (May 2022)

Revisited starter script from January 2021: Split Excel file into separate files Excel is essential, and Python is the future - forcing ourselves to practice the latter by automating some of the commo

Message us or

Call us on +44 (0)20 3287 8283

Mon to Fri: 8am-8pm

Weekends: 10am-6pm

bottom of page