Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
Attached is the excel file where my month and year are in text format.
By using that fields I need to calculate Fiscal month,Fiscal Year, Calender month ,Calender year by using that values
How Can i those value to number format.
Means if I apply num(Month) it should show value like 5 (If I select may).
Please help me.
Try like this:
=date(Date#('Apr-2011', 'MMM-YYYY'))
By knowing how to convert the date into numbers you could create a calendar.
May be like this:
Date(MonthStart(Date#(Month, 'MMM-YYYY')), 'MMM-YYYY') as MonthYear
Dear Sunny,
Thanks for Reply.
How can I create master calender with financial year, month from MonthYear field.
Regards
Tripati
The same way you would do with a date field. Just used MonthYear field instead of date in your master calendar creation script