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