Hello
Looking to populate Fiscal Month, Fiscal Year, Fiscal Period in rows 3,4,5 based on what the calendar date in row 2 is. I've done another tab for mapping the Fiscal calendar.
Stuck on how to return the relevant fiscal month, year and period, by doing a lookup between the Calendar date on Data tab to column A in Fiscal Calendar tab. Want to return 2020P9 for any August dates in 2020 for example
Thanks
Bookmarks