1

I have been asked to make a list that contains a calculated column containing the week number within a fiscal year starting on 6th April 2015 (Monday) So for example, 6th-12th April would be week 1, 13th-19th April week 2 and so on.

Current columns are Title, Date, Expected Fin week (what it should be) and calculated fin week (new).

So I would need the calculated fin week to be based upon the Date column (but I presume you knew this already)

I'm a very new, basic user of SharePoint so any help on this at all would be fantastic, thanks very much.

Bash.

1

There is no direct function which can give you this value. You can calculate this based on

  1. Find number of weeks between January and April
  2. Find number of weeks from your Date Field and January
  3. Now Add Result of #1 wit Result of #2

You can find week from date using formula

=INT(([DateField]-DATE(YEAR([DateField]),1,1)+(TEXT(WEEKDAY(DATE(YEAR([DateField]),1,1)),"d")))/7)
  • Thanks for the quick response but I'm not 100% on what you mean for the steps. Using that formula is giving me the correct fiscal week which is starting from January, so how can I make it start from the 6th of April. I realise I am repeating myself but I am very new to SharePoint so this doesn't really mean too much to me, do I need to make another column for the weeks between January and April? – Bash Apr 22 '15 at 15:23
  • Yes. You need two formulas. Then combine both to get what you want. I can't try now. – Amal Hashim Apr 22 '15 at 15:26

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.