FOrmula for Reaccuring Dates

  • Thread starter Thread starter Michael.Boyd89
  • Start date Start date
M

Michael.Boyd89

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)
 
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
 
Hi again , Still having the Same #Value Problem..... ive installed the
ToolPak... But it is still displaying the Value sign.....
 
Back
Top