Hi team
is there any formula to get the below result in the same sheet
2014/011
2014/010
Regards, Keerthi
Hi team
is there any formula to get the below result in the same sheet
2014/011
2014/010
Regards, Keerthi
Assume your data 2014/011 is in F1, then in F2 =LEFT(F1,4)&"/0"&RIGHT(F1,2)-1
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Thanks Alan, however I need the formula to be changed when the system date change.
Thanks Alan, however I need the formula to be changed when the system date change.
Please see the sample
see attached file
1 is with custom format
2 is with formula
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Thanks for the assistance and much obliged
Thanks for your feedback
One more quick question, if we want to put different year on the same then how the formula will be
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks