Posted to microsoft.public.excel.misc

Mike H

external usenet poster

Posts: 11,501

Automatic Update for Date

Perhaps this

=IF(WEEKDAY(TODAY())<7, TODAY()+6-WEEKDAY(TODAY()), TODAY()+6)

Mike

"txdude1" wrote:

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how can i set up an automatic "date update" in excel?	Litzyam	New Users to Excel	3	April 5th 23 02:55 PM
Automatic Update for Date	txdude1	Excel Discussion (Misc queries)	5	December 18th 08 07:47 PM
Automatic update of date once, then remains static	mfdc_frank	Excel Worksheet Functions	5	October 5th 06 12:16 AM
Automatic Date Update	Jmoore	Excel Worksheet Functions	1	November 17th 05 08:21 PM
Automatic Date Update	khaji00	Excel Discussion (Misc queries)	2	June 22nd 05 11:48 PM

All times are GMT +1. The time now is 04:33 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us