NOW AND TODAY

[THill]

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

 

[Gary''s Student]

Put a time in A1 and in B1 enter:

=IF(A1>0.2916666666,TODAY(),TODAY()-1) and format as a date

 

[Pete_UK]

Try this:

=IF(MOD(NOW(),1)>=7/24,TODAY(),TODAY()-1)

Hope this helps.

Pete

 

[THill]

Thank you so much

Try this:

=IF(MOD(NOW(),1)>=7/24,TODAY(),TODAY()-1)

Hope this helps.

Pete

 

[Pete_UK]

You're welcome.

Pete

 

[T. Valko]

Try this:

=TODAY()-(HOUR(NOW())<7)

Format as DATE

 

[Pete_UK]

Neat one, Biff.

Pete

Try this:

=TODAY()-(HOUR(NOW())<7)

Format as DATE

--
Biff
Microsoft Excel MVP








- Show quoted text -

 

[daddylonglegs]

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)

 

[T. Valko]

Even better!

--
Biff
Microsoft Excel MVP

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)