Posted to microsoft.public.excel.misc

shantanu oak shantanu oak is offline

external usenet poster

Posts: 7

Convert formulae to UDF

=IF((ROUNDUP(MONTH(A1)/3,0)=1),"31/03/"&(YEAR(A1)),
IF((ROUNDUP(MONTH(A1)/3,0)=2),"30/06/"&(YEAR(A1)),
IF((ROUNDUP(MONTH(A1)/3,0)=3),"30/09/"&(YEAR(A1)),"31/12/"&(YEAR(A1)))))

I have the formulae that I want to convert to UDF and use it in my VBA
project.
Please let me know how do I write a function out of it.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Recalculation of formulae disabled	Astroskibiker	Excel Discussion (Misc queries)	2	June 3rd 06 01:21 AM
Change to formulae	Emma Hope	Excel Worksheet Functions	3	September 5th 05 09:16 PM
Convert decimal degree (lattitude/longitude) into Degree,	Tim Ashcom	Excel Discussion (Misc queries)	5	August 17th 05 04:53 PM
CONVERT Function Disappered in Excel	Gord Dibben	Excel Discussion (Misc queries)	3	April 13th 05 07:59 PM
Convert Numeric into Text	Monty	Excel Worksheet Functions	0	December 18th 04 09:25 PM

All times are GMT +1. The time now is 02:29 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us