Posted to microsoft.public.excel.programming

mudraker[_276_] mudraker[_276_] is offline

external usenet poster

Posts: 1

Week Ending Formula

Jako

This will give next Saturday's date

dDate = DateValue(Now()) + (7 - WeekDay(Now())

--
Message posted from http://www.ExcelForum.com

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
Week ending Thursday formula	Laurence Lombard	Excel Worksheet Functions	5	April 26th 23 07:43 PM
Convert regular Date to Week Ending or Week Beginning Dates	Sam H	Excel Discussion (Misc queries)	5	April 3rd 23 04:39 PM
Formula for week ending	Nelix	Excel Worksheet Functions	2	April 10th 09 06:20 PM
Week Ending formula	cindi	Excel Discussion (Misc queries)	2	July 11th 07 09:03 PM
Week ending	[email protected]	Excel Worksheet Functions	3	November 1st 05 04:52 PM

All times are GMT +1. The time now is 09:24 PM.

About Us

"It's about Microsoft Excel"