How to use the =TODAY() for start up but freeze that date
Requirement:
The user is working on a worksheet for hours worked each day of the week. The user needs the date to be the correct date on start up, but not to change the next consecutive days of the week. The user needs to freeze the date so that it doesn't change tomorrow or the consecutive dates until 7 days later.
Solution:
=TODAY()-CHOOSE(WEEKDAY(TODAY(),16),0,1,2,3,4,5,6)
Obtained from the OzGrid Help Forum.
Solution provided by AliGW.
See also: Index to Excel VBA Code and Index to Excel Freebies and Lesson 1 - Excel Fundamentals and Index to how to… providing a range of solutions and Index to new resources and reference sheets
See also:
| How to remove slashes from date |
| How to calculate duration difference between two dates |
| How to convert US to UK dates |
Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.
Gallery
