Posted to microsoft.public.excel.misc

Andrew Mackenzie Andrew Mackenzie is offline

external usenet poster

Posts: 50

Date Question

In row A I have dates 31-Jan-08, 28-Feb-08, 31-Mar-08...etc.

In row B I want an =IF function such that a certain formula will apply if
the date is 31st December, regardless of the year.

Can anyone tell me how to refer to the date in such a funtion? i.e.
=IF(A1=?????,25*3,25*4) if A1 is 31-Dec-** then 25 times 3, otherwise 25
times 4.

Many thanks for any help

Andrew

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
Date question	Jman	Excel Worksheet Functions	8	June 1st 07 10:43 AM
Date question	[email protected]	Excel Worksheet Functions	2	September 2nd 06 10:14 PM
Date Question	scwilly	Excel Worksheet Functions	3	April 26th 06 09:24 AM
Date question	Bri	Excel Worksheet Functions	2	February 8th 06 02:36 AM
Date Question	John	Excel Discussion (Misc queries)	4	January 15th 06 06:33 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us