Forum Discussion
Jessica_Malone_1989
Aug 04, 2022Copper Contributor
Modifying an Existing General Ledger Doc. in Excel
EXCEL geniuses... I need help trying to change a fiscal date range in a general ledger provided by Excel. Something to do with the date value... They have it set with Jan - Dec. Ours needs to be October through September. How do I change this????
- LorenzoSilver Contributor
In the cell you highlighted:
=DATEVALUE("1-OCT"&_YEAR)
then copy right until column O