jondallimore
Board Regular
- Joined
- Apr 26, 2012
- Messages
- 136
Hello.
Im using this formula:
=TODAY()+(7-WEEKDAY(TODAY(),2)+1)
To return the date of the next monday after today, which works fine.
Is there a way to make sure that the date "locks" in place when the next monday is reached?
For example, today is the 11th, so the formula gives the 13th, which is the next monday. However, on the 14th, the formula will show the next monday again. Is there a way to lock the cell to the 13th when the 13th is reached?
Hope that makes sense
Thanks
Jon
Im using this formula:
=TODAY()+(7-WEEKDAY(TODAY(),2)+1)
To return the date of the next monday after today, which works fine.
Is there a way to make sure that the date "locks" in place when the next monday is reached?
For example, today is the 11th, so the formula gives the 13th, which is the next monday. However, on the 14th, the formula will show the next monday again. Is there a way to lock the cell to the 13th when the 13th is reached?
Hope that makes sense
Thanks
Jon