Extract financial year from dates

Comments

Post a Comment

Popular posts from this blog

Nepali Functions Addin for Excel V6

Image
http://sajanmaharjan.com.np/my-works/nepali-functions-addin-for-excel/ It has been sometime that people had been requesting for an excel utility that would perform the date conversion from AD to BS and vice versa in Excel itself. Finally, I have had the time to program it and hope that it can help you in some way. You can download the file here. DOWNLOAD SAJAN.NEPALI.FUNCTIONS.V6.XLAM Available Functions Example Description AD2BS( “enter_ad_date” ) AD2BS( "12/25/2016") AD date format ( MM/DD/YYYY ) BS2AD( “enter_bs_date” ) BS2AD( "2073/12/25") BS date format ( YYYY/MM/DD ) number2words( enter_number ) number2words( 123 ) Returns the result in preeti font number2words_preeti( enter_number, show_units ) number2words_preeti( 123 ) Returns the result in preeti font. Here show_units is optional and set to false by default; Shows paisa count if set to true. number2words_unicode( enter_number, show_units ) number2words_unicode( 123 ) Returns the result i...
Read more

How to Unprotect an Excel Spreadsheet if you have lost your password.

Image
 http://www.excelsupersite.com/how-to-unprotect-an-excel-spreadsheet-if-you-have-lost-your-password/ How to unprotect a password protected worksheet.   So what do you do… In the case of a password protected worksheet where you are unable to Edit the data you can try the following steps to unprotect your worksheet.   Step 1  Press ALT +  F11 or click View Code on the Developers Tab   Step 2  Double click on the worksheet that is password protected. Step 3  Copy and paste the code below into the (Code) window. Do not change any of the code, just copy and paste it. Sub PasswordBreaker () Dim i As Integer , j As Integer , k As Integer Dim l As Integer , m As Integer , n As Integer Dim i1 As Integer , i2 As Integer , i3 As Integer Dim i4 As Integer , i5 As Integer , i6 As Integer On Error Resume Next For i = 65 To 66 : For j = 65 To 66 : For k = 65 To 66 For l = 65 To 66 : For m = 65 To 66 ...
Read more