weekly date update
Hi I have had success in the past using this site and once again i hope you can help,
I have a date in D1 which is just todays date "=now()"
G2 then shows this coming Saturday just typed in manually.
H2:AD2 are then G2+7, H2+7 and so on.
I am looking for a way to change G2 automaticlly to the Saturday following the date shown in D1.
Hope someone can help.
Thanks
K
Maybe: =G2-WEEKDAY(G2)+7
Assuming if the date entered is a Saturday it should return the same date.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks