Forum Discussion
Return the starting date of a fiscal week
Hi, I'm new to Excel. I want to include a column with values of starting date of each week in fiscal week column. How can I achieve the second column using a formula or other method? First fiscal...
Hi NikolinoDE. Thanks for your info. The only data I have is the first column (Fiscal Week). What I want to achieve is that start date of the said fiscal week (second column). I put there only to show that these are the results I need.
Please see the attached file for a detailed overview.
=("4.1."&YEAR(A2))+B2*7-7-MOD("2.1."&YEAR(A2);7)