Is there syntax for being able to reference a cell with the period # and write out the full date. Example
10 is in the period cell used for communications
but I want another cell to say 'as at October 31' where period 10 to Sage is October.
Is there syntax for being able to reference a cell with the period # and write out the full date. Example
10 is in the period cell used for communications
but I want another cell to say 'as at October 31' where period 10 to Sage is October.
I'm sure you can do this with a SQL expression, but an easy way is with an Excel Expression like the following:
TEXT(EOMONTH(DATE(2000,C2,1),0),"mmmm dd") Where c2 is 10. I just picked 2000 as the year, but it could have been any year.
*Community Hub is the new name for Sage City