Thread: How do I create a formula that will do YTD calculations?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Carim Carim is offline
external usenet poster
  
Posts: 510
Default How do I create a formula that will do YTD calculations?
Hi,

With the same assumptions as via135, in cell C1 :
=IF(YEAR(A1)<YEAR(B1),(B1-(DATE(YEAR(B1),1,1)))/7,(B1-A1)/7)

HTH
Carim

Reply With QuoteReply With Quote