I created a master document to use each week to input jobs employees have completed. I am using:
=TODAY()-WEEKDAY(TODAY(),3)+IF(WEEKDAY(TODAY(),3)>4,11,4)
to display the upcoming Friday's date in a cell. However if I open up this saved document 3 weeks later to print it, it changes the date.
What can be done to keep it from changing once the date actually gets here.
Not a lot with the existing formula. TODAY() is a volatile function and will change as the date changes.
You would be better using the Excel shortcut key combination Ctrl-; (that is the Ctrl key pressed with the semi-colon key) to enter the current date into a specific cell, say, cell A1.
Then thisbecomes thisFormula:
Please Login or Register to view this content.Formula:Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks