All articles with 'user defined functions' Tag

Get cell comments using Excel Formula

Published on Sep 3, 2009 in Learn Excel, VBA Macros
Get cell comments using Excel Formula

Excel has a very useful feature called “cell comments” using which you can add comment to a cell. This is a very good way to gather remarks and review comments when a workbook is shared with colleagues and others. But what if you have typed a ton of cell comments and now want a way to extract them and do something with that data?

Continue »

Networkingdays() an improved version of networkdays formula

Published on Jun 9, 2009 in Excel Howtos, Learn Excel, VBA Macros
Networkingdays() an improved version of networkdays formula

We all know that networkdays() an extremely powerful and simple excel formula can help you calculate no. of working days between 2 given dates.

But there is one problem with it. It assumes 5 day workweek starting with Monday to Friday. Not all countries have workweek from Monday to Friday.

This got me thinking and I ended up writing a user defined formula (UDF) to calculate working days between 2 given dates with any criteria. This will be good for calculating payrolls for temporary workers, offshore partners and of course people working countries where Saturday or Sunday or not usually holidays.

Continue »