Posted to microsoft.public.excel.programming

jimmy[_5_] jimmy[_5_] is offline

external usenet poster

Posts: 37

Check date

Hi all,

I've written the following formula to check if it is the first Monday after
every 29th. It seems work but I don't know it is correct or not, please give
advice, many thanks.

=AND(DAY(G3+7-WEEKDAY(G3-2)-6)=23,DAY(G3+7-WEEKDAY(G3-2)-6)<=29)

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
Check the Date	stewdizzle	Excel Programming	3	February 4th 07 03:14 PM
Date Check	Aaron	Excel Programming	1	November 16th 06 11:25 PM
Change text to date and check against date in cell	RW	Excel Programming	3	February 2nd 06 03:29 PM
Check for date	Kjeldc	Excel Programming	8	November 30th 05 03:21 AM
Check date	Ben	Excel Programming	2	December 21st 04 06:18 AM

All times are GMT +1. The time now is 05:12 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us