R
Rachel Costanza
I have a an excel workbook with 15 worksheets that I have to update the prior
month and current year on every month to produce a turnover report. Can I
use VB or a DATE function to do this?
I have tried =TEXT(TODAY(),"mmmm") but that only gives me the current month
and not the year. I need the prior month and current year.
Any help is appreciated!
Best,
Rachel Costanza
month and current year on every month to produce a turnover report. Can I
use VB or a DATE function to do this?
I have tried =TEXT(TODAY(),"mmmm") but that only gives me the current month
and not the year. I need the prior month and current year.
Any help is appreciated!
Best,
Rachel Costanza