HI
i am new to excel, i have been learning from YouTube videos and excel forums. It took me a awhile but at last i did my first dashboard / Templet.
but i am lost at the last stage of the templet. i couldn't come up with any solution. i am posting it here hoping someone will assist me
Background :
Facility Total Patients Remaining Patients Remaining Daily Target
Clinic 1 2417 2417 219,73
Clinic 2 2075 2075 188,64
Clinic 3 1271 1271 115,55
Clinic 4 1257 1257 114,27
i need to track the progress on daily basis
templet will ask to input for dead line , based on deadline templet calculate the Daily target.
Daily progress is indicated on the Calander section of the templet.
problem:
templet will only generate the 1 month at a time, if i set deadline for 2 months and the after the end of first month, somehow i need to capture the progress on the following month and should be able to track the progress for 2 months on same templet
i have attached the templet for reference
Kindly assist
Keys
Bookmarks