Posted to microsoft.public.excel.programming

Simon[_2_] Simon[_2_] is offline

external usenet poster

Posts: 89

IF DATE Statement help please

Hi I would like to use the following type of statement (I think
unfortunately my brain is in "Excel not VBA mode"):

IF

Then Else

Or Else

I wish to use the criteria that If date (date = 1st of the month) AND
Day = Sun, =Range("A1")
If Day = Sat AND DATE = 1 = Range("A2")
Else = Range("A3")

Thanks for your help

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
If Statement for a date	jlo	Excel Worksheet Functions	4	June 17th 09 06:02 PM
if statement with date	JJ	Excel Worksheet Functions	2	April 9th 09 08:03 PM
How can I use a date in an IF/AND statement?	gsmith	Excel Discussion (Misc queries)	2	July 13th 05 12:27 AM
If statement with date	Tanya	Excel Discussion (Misc queries)	4	May 20th 05 01:42 AM
Date in an IF statement	LyndieBee	Excel Worksheet Functions	2	March 8th 05 04:11 PM

All times are GMT +1. The time now is 12:17 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us