Help with Dates and Day of week

[ajc623]

I have a sheet where I would like for A1=the next workday (M-F) formatted as mm/dd/yy so if today is 1/3/2014 (a Friday) I would want A1=01/06/14 if today was 1/6/14 (A monday) I would want A1= 01/07/14. . Also it would be nice to have it not be something that is not like =today()+1 as I copy and rename the sheet each night and would like for the date that schedule was created for to remane on the sheet. I am sure there is an easy way to do this but I cant figure it out
THanks

Andrew

 

[Snakehips]

Andrew,


This formula in A1 should give you your next workday...

=WORKDAY(TODAY(),1)

As for fixing that date when you save and rename I think that you have two options.

If you copy and rename the sheet manually then when you have the copied sheet, select A1, Copy, Paste Special, Values.

If you use a macro or are wanting / able to then the formula can be converted to value within that macro.

Come back if you require the Macro option.
Hope that helps.

 

[ajc623]

Thanks that worked great!