Archives for: December 2015

IF Statement Wished Me (happy new year)

Formulas
Howdy,   =IF(YEAR(TODAY())=2016,"A VERY HAPPY AND PROSPEROUS NEW YEAR","")   :)   Thanks and see you again more »

Count "Mondays" Between Two Dates

Formulas, How-to's
Hi there, FORMULA: =SUMPRODUCT(--(TEXT(ROW(INDIRECT(end_date&":"&start_date)),"DDDD")="specific_day")) EXPLANATION: more »

Show Invisible Cell Content ( its Advantages)

Excel Tips
Hi there,   In this post, we will discuss about how to make the cell content invisible from other users until the user activate that cell. The cell content is visible only through formula bar. more »

Converting Time Zones using Excel (Quick tip)

Formulas, How-to's
Hello Howdy's   How are you doing today? Hope you are doing awesome. In this post, we will discuss about converting one time zone to another by using simple logic in excel. If you already have an idea on how to achieve this results, please pause read… more »
Contact / Help. ©2019 by Abhilash VK. Design & icons by N.Design Studio. Skin by Tender Feelings / Skin Factory.