Automatic Update for Date

T

txdude1

But I want the date to only be Fridays. Each week it has the date of that
Friday & then it automatically changes the next week to that Friday. How do
I do this? If the TODAY function will do this then I need someone to explain
to me in detail how to do this.
 
L

Luke M

Try to reply in the same thread, so other poster's suggestions can be seen by
all.

David's formula of
=TODAY()+MOD(6-WEEKDAY(TODAY()),7)

will do exactly what you want, only showing Fridays.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to automate update on weekly reports spreadsheet 0
Formula to display next Friday from B1 works except on the Friday itself. 4
Display weeks from a Milestone 0
Search closest day in the past from today 2
Calculate Date automatically in word 2007 1
How do I post date a letter? 1
Automatic Update for Date 5
Style Gallery View 3

Top