NOW AND TODAY
Thank you so much
"Pete_UK" wrote:
Try this:
=IF(MOD(NOW(),1)=7/24,TODAY(),TODAY()-1)
Hope this helps.
Pete
On May 17, 12:48 pm, THill wrote:
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
|