Date - help

[Julian Campbell]

I have a spreadsheet with 5 pages, 1 for each work day of the week. I have
placed in each page a date formula =TODAY(). Is there a way of locking the
date after each day ie Monday 1st September will remain as Tuesday goes to
2nd and that remains as the other days progress?

At the end of each week, the shhets are cleard and started from Monday again

Thanks

Julian

 

[Frank Kabel]

Hi
not possible without using VBA

 

[Julian Campbell]

Thanks Frank...Is VBA a difficult thing to grasp? Whats the best way to look
at what you can achieve with VBA

Thanks

 

[Brian]

try =Today()+1 in tuesdays sheet then =Today()+2 for Wednesday etc