Showing Year and Month In Day Prediction

Hi All

I am trying to do a daily prediction based on Patient Data. While doing this the forecast returns the correct periods and sub periods. The problem is the Period returned is at a Week level and the Sub-Period returned is the Day Number.

Is there a way to show the year and Month corresponding to the predicted week and day.

For example if my Period is 105 and Sub_Period is 1

i would need to show the output as 2018 Jan and week 1 and 2018-01-01

I have data from 2016 at a day level from 2016 through 2017

Week.yxzp

Predictive Analysis

Accepted answers

BenMoss

I managed to download and bring through the macro's myself.

Here is my solution, I have created a date field and a week field, I may not have the week field in exactly the structure you desire but now we have the date field this should be very simply to do using the datetimeformat() function (see my week formula as an example).