 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / May 2008NOW 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 Put a time in A1 and in B1 enter: =IF(A1>0.2916666666,TODAY(),TODAY()-1) and format as a date  SignatureGary''s Student - gsnu200786 Try this: =IF(MOD(NOW(),1)>=7/24,TODAY(),TODAY()-1) Hope this helps. Pete > Is ther anyway to combine the now and today fuctions in a logic formula? > Somehting like.... [quoted text clipped - 4 lines] > > Thank You Thank you so much > Try this: > [quoted text clipped - 12 lines] > > > > Thank You Try this: =TODAY()-(HOUR(NOW())<7) Format as DATE SignatureBiff Microsoft Excel MVP > Is ther anyway to combine the now and today fuctions in a logic formula? > Somehting like.... [quoted text clipped - 5 lines] > > Thank You Neat one, Biff. Pete > Try this: > [quoted text clipped - 17 lines] > > - Show quoted text - If it's just for display purposes =NOW()-7/24 format as date If you want the underlying value to be a date only, add an INT function, i.e. =INT(NOW()-7/24) > Try this: > [quoted text clipped - 11 lines] > > > > Thank You Even better! SignatureBiff Microsoft Excel MVP > If it's just for display purposes > [quoted text clipped - 23 lines] >> > >> > Thank You |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.