Below is a possible solution to the Challenge 63 - Convert to Date Format
Put following formula and drag down
SUBSTITUTE(A1,",","")," ","*",2),"*",", "))
This time, you have been given a file containing Text dates into various formats. The challenge before you is to write a single formula to convert them into an appropriate date format.
The challenge file can be downloaded from Challenge 63 - Convert to Date Format
The solution to the above challenge will be published after a month i.e. on 10-Jul-17.
Below is a possible solution to the challenge - Challenge 60 - Generate a list of 2nd and 4th Saturdays for a Year
Drag the below formula down
In India, 2nd and 4th Saturdays are very important days as on these days, the banks remain closed. Hence, banks in India are closed on all Sundays and 2nd and 4th Saturdays apart from their holiday calendar.
To calculate Networkdays for banking industry in India needs that the list of 2nd and 4th Saturdays needs to be generated. You know the syntax of NETWORKDAYS -
NETWORKDAYS.INTL(Start_Date, End_Date, [Weekend],[Holidays])
In weekend parameter, we can specify Sunday as weekend and in Holidays list, we can put the holidays and also the 2nd and 4th Saturdays.
Now, the challenge before you is to write a formula which takes Year as Input from A1 and which when dragged down produces the 2nd and 4th Saturdays.
Note - The solution to above problem will be published after a month i.e. on 25-Mar-17.
Below is the VBA function where you can convert a given amount into Words on the basis of Indian Currency. India utilizes a system which is based on Hundred, Thousand, Lakh.....unlike English system which is based on Hundred, Million, Billion..(Indian Numbering System)
Below are numerical equivalent of Indian words
Lakh - 1,00,000
Crore - 1,00,00,000
Arab - 1,00,00,00,000 (more…)