Thread: How do I get the Fortnight number of the year from a date?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default How do I get the Fortnight number of the year from a date?
Maybe this,

=ROUNDUP((A1-DATE(YEAR(A1),1,0))/14,0)

Mike

"Daz" wrote:

I want to get the fortnight number of the year into a cell, i.e 1-1-2009 will
be fortnight number one and 15-1-2009 will be fortnight number 2.

As well as the date I also have the day number of the year
Reply With QuoteReply With Quote