Posted to microsoft.public.excel.worksheet.functions

Sean

external usenet poster

Posts: 454

Specific Days in a NOW() formula Q

I have the formula below which states that if NOW is greater than the
Time in B1 (which is 3:00pm) then return NOW, oherwise return 3pm.

=IF(NOW()B1,NOW(),B1)

How would I construct a formula that says if the days is any day other
than Tuesday or Wednesday, then use the formula above, but if it is
Tuesday or Wednesday, then B1 should be 8:00pm?

Thanks

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
Calculating Excess Days Formula	richardwo	Excel Worksheet Functions	4	January 30th 07 04:21 PM
Reusing formula	Tony29	Excel Discussion (Misc queries)	7	September 7th 06 03:34 AM
Match then lookup	Tenacity	Excel Worksheet Functions	9	December 3rd 05 05:30 AM
Vacation Accrual Formula	MissNadine	Excel Worksheet Functions	0	August 18th 05 04:02 AM
Formula for # of sales days in a month?	Kerry Rosvold	Excel Worksheet Functions	2	June 1st 05 09:11 PM

All times are GMT +1. The time now is 09:08 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us