Hello all,

I need to convert dates into periods in an excel sheet.

For example 1/1/2007 - 28/1/2007 = P1
29/1/2007 - 25/2/2007 = P2
....until P13 (13 periods of 4 weeks). So a period does not necessarily
match the number of the month. (eg. 20/12/2007 = P13)

If a cell for example says 10/1/2007 "P1" should be returned, if
25/12/2007 - "P13", ...

I tried things like "=IF(1/1/2007<A1<28/1/2007; P1, ...)" but that
doesn't work.

thanks for your advice on this one !

Xavier