Get Date from Week Number and Year ( Fiscal Calendar)

**tantcu** · 01-22-2013, 11:17 AM

Hi,

I'm having a data only pull week number and year. We are using Fiscal calendar starting in July. For example, A1 = Week number and A2= Year. Does anyone know how to set up a formula to retrieve a date for this? If A1 = 2 , A2 = 2013, the date will be 07/14/2012. I want the date pull of on Saturday every week.

**bebo021999** · 01-22-2013, 11:38 AM

Try this:
=DATE(A2,7,1)-2+WEEKDAY(DATE(A2,7,1))+A1*7
In which: DATE(A2,7,1)-2+WEEKDAY(DATE(A2,7,1)) returns the last saturday before (30/6/2012), multiply number of weeks to show the expected saturday of the given weeks and years

**alansidman** · 01-22-2013, 11:40 AM

Build a table with week numbers and the Saturday date. Then use Vlookup. Example attached.

**tantcu** · 01-22-2013, 12:10 PM

Hi bebo021999,

I don't think your formula works for fiscal calendar year which beggining of the year in July. It works for year end calendar start in January.

**mjt222** · 05-08-2013, 12:59 PM

Hi there, wondering if someone can help, but I would like to align week numbers to individual days of a week, so assuming that the year starts on Monday 25/03/13, this being week 1, I would need all days for this week showing as week 1 and then on Monday 01/04/13 showing as week 2, repeated for the whole year? Iv been trying various formats of formula but with no joy.

Any ideas?

Thanks

Martin

**arlu1201** · 05-08-2013, 01:42 PM

Martin,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.