Menu

Auto placement of date

Search this Thread

#1

Report Post

Don Guillett

Posts: n/a

Default

glad it helped

--
Don Guillett
SalesAid Software

"Carolyn" wrote in message
...
Don:

I put the TODAY function in F7 and got 05/1/05 in the cell I put this
formula. Neat!
Many thanks.

Carolyn
"Don Guillett" wrote:

try
=F7-WEEKDAY(F7-1)+7-(WEEKDAY(F7)=6)*7

--
Don Guillett
SalesAid Software

"Carolyn" wrote in message
...
Is there a way to have the date of the Sunday following the date the
spreadsheet is opened to automatically entered?

Carolyn E. Weiss

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
auto dating after entering the first date	Jomo Watts	Excel Worksheet Functions	2	April 5th 05 03:05 PM
how do i set an auto date function in excel or word?	hpkcommish	Excel Discussion (Misc queries)	2	February 22nd 05 10:23 AM
assign auto number and auto date	Krit Kasem	Excel Discussion (Misc queries)	2	January 14th 05 02:55 AM
auto entry of a date	Richard Rosell	Excel Worksheet Functions	2	December 27th 04 03:26 PM
Auto date changing in Excel is maddening	brhicks	Charts and Charting in Excel	3	December 16th 04 02:54 PM

All times are GMT +1. The time now is 08:43 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement