How to update 2 cells in a file with out opening the file

Core4

New member
Joined
Jun 2, 2020
Messages
1
Reaction score
0
Points
0
Excel Version(s)
365
Hello, we use an excel document as an invoice for our clients. Once it's created specifically to their info it only needs to be opened each month to change the "date & month" in 2 cells. I was hoping there was a way to apply that change to the 300 + invoices (workbooks) with out having to open each one. Appreciate any help I can get. I've attached a sample of the invoice and highlighted the 2 cells that need to be updated each month.
Thank you
 

Attachments

  • Sample Invoice.xlsx
    20.6 KB · Views: 5
.
Paste this formula in H3 :

Code:
=TODAY()-DAY(TODAY())+1
 
Back
Top