Thread: Formula to VBA codes
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Savio Savio is offline
external usenet poster
  
Posts: 19
Default Formula to VBA codes
is there any way to do this using VBA?

=-(IF(AND(WEEKDAY(A1,2)<6,MOD(A1,1)17/24),1,0)+WEEKDAY(A1,2)6)+2*(IF
(AND( WEEKDAY(A1,2)<6,MOD(A1,1)17/24),1,0)+WEEKDAY(A1,2)5)+A1

thanks
Reply With QuoteReply With Quote