Custom week number / Custom Fiscal year

[rashid67]

Hello,
I am trying to create a custom week number formula where week starts on Saturday and ends Friday. The fiscal year starts from 02/01/2018 and ends on 01/31/2019

** This how i want week number list to start and end.

The three columns, first column shows week number, second showing corresponding start date and third showing end date. All the formulas should be based on year start date and end date (shown above)

[TABLE="width: 500"]
<tbody>[TR]
[TD]Week No[/TD]
[TD]Start date[/TD]
[TD]end date[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][TABLE="width: 66"]
<tbody>[TR]
[TD]Jan/27/2018[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]Feb/02/2018[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Feb/03/2018[/TD]
[TD]Feb/09/2018[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Feb/10/2018[/TD]
[TD]Feb/16/2018[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]53[/TD]
[TD]Jan/26/2019[/TD]
[TD]Feb/01/2019[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Thanks,

RJ

 

[crazydragon84]

well, you only need formula on the first week start date. the rest can just do +7 days from previous row start date and + 6 on end date.

In the first row, you can do a calc on weekday of year start date. Start Date should be =IF(WEEKDAY(Year_Start_Date)=7,Year_Start_Date,Year_Start_Date-WEEKDAY(Year_Start_Date)). hope that helps.

 

[rashid67]

Thanks, it works.

Appreciate your help.

RJ