Hi im currently producing Monthly reports for my company, and i was just
wondering if you could have a formula or something that would make it so that
when i change the Start Date for Example Monday 1st it would automatically
change the Next 6 Days in order too the first date ive entered? Thanks for
Any replys in advance

Certainly. For simple day progression, if A2 is your input cell, in B2:
=A2+1
and copy across. If you only want workdays:
=WORKDAY(A2,1)
and copy across.
(Note that WORKDAY requires the Analysis ToolPak add-in to be active)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Michael.Boyd89" wrote:

Hi im currently producing Monthly reports for my company, and i was just
wondering if you could have a formula or something that would make it so that
when i change the Start Date for Example Monday 1st it would automatically
change the Next 6 Days in order too the first date ive entered? Thanks for
Any replys in advance

Hi thanks for the Speedy Reply
I have done as you said but i keep getting this message #VALUE! does this
mean i do not have the analysis toolpak addin? Thanks


"Luke M" wrote:

Certainly. For simple day progression, if A2 is your input cell, in B2:
=A2+1
and copy across. If you only want workdays:
=WORKDAY(A2,1)
and copy across.
(Note that WORKDAY requires the Analysis ToolPak add-in to be active)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Michael.Boyd89" wrote:

Hi im currently producing Monthly reports for my company, and i was just
wondering if you could have a formula or something that would make it so that
when i change the Start Date for Example Monday 1st it would automatically
change the Next 6 Days in order too the first date ive entered? Thanks for
Any replys in advance

From menuToolsAdd-Ins Check 'Analysis ToolPak' and try the formula again


"Michael.Boyd89" wrote:

Hi thanks for the Speedy Reply
I have done as you said but i keep getting this message #VALUE! does this
mean i do not have the analysis toolpak addin? Thanks


"Luke M" wrote:

Certainly. For simple day progression, if A2 is your input cell, in B2:
=A2+1
and copy across. If you only want workdays:
=WORKDAY(A2,1)
and copy across.
(Note that WORKDAY requires the Analysis ToolPak add-in to be active)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Michael.Boyd89" wrote:

Hi im currently producing Monthly reports for my company, and i was just
wondering if you could have a formula or something that would make it so that
when i change the Start Date for Example Monday 1st it would automatically
change the Next 6 Days in order too the first date ive entered? Thanks for
Any replys in advance

Hi again , Still having the Same #Value Problem..... ive installed the
ToolPak... But it is still displaying the Value sign.....

"Jacob Skaria" wrote:

From menuToolsAdd-Ins Check 'Analysis ToolPak' and try the formula again


"Michael.Boyd89" wrote:

Hi thanks for the Speedy Reply
I have done as you said but i keep getting this message #VALUE! does this
mean i do not have the analysis toolpak addin? Thanks


"Luke M" wrote:

Certainly. For simple day progression, if A2 is your input cell, in B2:
=A2+1
and copy across. If you only want workdays:
=WORKDAY(A2,1)
and copy across.
(Note that WORKDAY requires the Analysis ToolPak add-in to be active)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Michael.Boyd89" wrote:

Hi im currently producing Monthly reports for my company, and i was just
wondering if you could have a formula or something that would make it so that
when i change the Start Date for Example Monday 1st it would automatically
change the Next 6 Days in order too the first date ive entered? Thanks for
Any replys in advance