Thread: Convert formulae to UDF
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
shantanu oak shantanu oak is offline
external usenet poster
  
Posts: 7
Default 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 QuoteReply With Quote