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(A10.2916666666,TODAY(),TODAY()-1) and format as a date

--
Gary''s Student - gsnu200786

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

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

You're welcome.

Pete

On May 17, 1:45*pm, THill wrote:
Thank you so much

Try this:

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

Format as DATE

--
Biff
Microsoft Excel MVP


"THill" wrote in message
...
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

Neat one, Biff.

Pete

On May 17, 5:42*pm, "T. Valko" wrote:
Try this:

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

Format as DATE

--
Biff
Microsoft Excel MVP

"THill" wrote in message

...



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- Hide quoted text -

- 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)

"T. Valko" wrote:

Try this:

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

Format as DATE

--
Biff
Microsoft Excel MVP


"THill" wrote in message
...
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

Even better!

--
Biff
Microsoft Excel MVP


"daddylonglegs" wrote in message
...
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" wrote:

Try this:

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

Format as DATE

--
Biff
Microsoft Excel MVP


"THill" wrote in message
...
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