ExcelBanter - How do I get the Fortnight number of the year from a date?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I get the Fortnight number of the year from a date? (https://www.excelbanter.com/excel-discussion-misc-queries/212713-how-do-i-get-fortnight-number-year-date.html)

daz

How do I get the Fortnight number of the year from a date?

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

Mike H

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

All times are GMT +1. The time now is 07:52 PM.