Show Year & Fiscal Week (FW)

Hi,

I'm looking for a function that will show this: "2014 - FW 27"

In cell O4, I have the date, 07/01/14 or July 1, 2014

My log consists of some dates from 2013 & therefore, I need to distinguish the weeks from 2013 & 2014 with the format above

Right now, I have the following function:

=IF(WEEKNUM(O4,1)=53,1,WEEKNUM(O4,1))

In case FW 53 shows up, it will now show as FW 1

I'm looking to put the year in front it & not certain how.

Please advise.

Thanks

Please Login or Register  to view this content.

protonLeah,

Perfect!!

I knew it would be something relatively simple.

Thanks for the assistance.