Posted to microsoft.public.excel.worksheet.functions

THill

external usenet poster

Posts: 5

NOW AND TODAY

Is ther anyway to combine the now and today fuctions in a logic formula?
Somehting like....
if it from 7am to 11:59pm then display today and if it between 12am and 7am
display yesterdays date

Any help would be greatly appreciated

Thank You

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
Before today	MAustin	Excel Discussion (Misc queries)	2	October 2nd 07 04:54 PM
=TODAY()	Steved	Excel Worksheet Functions	7	June 12th 07 10:53 PM
IF TODAY equals date in cell A10, or if TODAY is beyond that date	SoupNazi	Excel Worksheet Functions	4	April 23rd 07 01:14 AM
How is everyone today?	MommaQ	Excel Discussion (Misc queries)	0	March 17th 05 03:15 PM
=IF(OR(TODAY()G9),"Pass","Overdue") Why doe it not wo.	Fkor	Excel Discussion (Misc queries)	3	March 10th 05 08:29 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us