update date of the week/month compared to today

hey Guys,

im looking for some code that will be able to tell what day/date of the week it is and then update a cell to the next tuesday for example. so if today is friday the 20th, i want to be able to set the cell A2 to reference tuesday the 24th, then on wednesday the 25th it will autmatically change to tuesday 31st

im creating a spreadsheet that requires some data to be entered at various times: on every tuesday, on the 4th of every month etc

i want a page that looks at todays date and says, the follow data needs to be updated


hope this is clear enough, having trouble getting accross what im trying to do.

any help always appreciated

thoughts?

thanks for the reply smuzoen

its close to what i need....

can you help me add a 'for each cell in column' to change for every cell from B15:B75 for example.

if so i think i can make it work with a little more manipualtion on my behalf

Pl try this formula.

=IF(WEEKDAY(TODAY(),1)=3,TODAY(),IF(WEEKDAY(TODAY(),1)<3,TODAY()+3-WEEKDAY(TODAY(),1),TODAY()+10-WEEKDAY(TODAY(),1)))