Hi friends
I have the following data with me:
31-May-2019
30-June-2019
31-Jul-2019
........
........
31-Oct-2023
While I would need these dates as values (for my other formulas in sheet), I want to "display" Quarter and Financial year number against selected dates on the Dashboard. For e.g. 31-May-2019 will have Q3F19 while 31-Oct-2020 will have Q4F20.
This will only be the 'Displayed text' while the actual value remains as Date, as my other calculations are using Date.
How can I get different displayed text than actual values, considering I have so many dates. Thanks in anticipation.
Cheers
I have the following data with me:
31-May-2019
30-June-2019
31-Jul-2019
........
........
31-Oct-2023
While I would need these dates as values (for my other formulas in sheet), I want to "display" Quarter and Financial year number against selected dates on the Dashboard. For e.g. 31-May-2019 will have Q3F19 while 31-Oct-2020 will have Q4F20.
This will only be the 'Displayed text' while the actual value remains as Date, as my other calculations are using Date.
How can I get different displayed text than actual values, considering I have so many dates. Thanks in anticipation.
Cheers