PDA

View Full Version : Excel Date over Midnight


TitoTito
May 8, 2012, 11:36 AM
Example of what I need:

Cycle: 07:00 AM one day to 07:00 AM second day

Date is 08.05.2012. (07:00 AM) (dd.mm.yyyy)

For period between 08.05.2012 07:00AM to 09.05.2012 07:00AM

In cell A1: 08.05.2012
In cell A2: 09.05.2012


When opening a document:

In cell A1: Current Date
In cell A2: Next Day Date

JBeaucaire
May 9, 2012, 11:50 AM
In cell A1: =TODAY() (formatted to display as you want)
In cell A2: =TODAY() + 1 (formatted to display as you want)

TitoTito
May 9, 2012, 12:24 PM
That's not what I need. That's what I use now. The result of these values ​​is:
If the date 08.05.2012. (07:00 AM) (dd.mm.yyyy), BEFORE MIDNIGHT 08.05/09.05

In cell A1: 08.05.2012
In cell A2: 09.05.2012

AFTER MIDNIGHT 08.05/09.05

In cell A1: 09.05.2012
In cell A2: 10.05.2012

I need:

For period between 08.05.2012 07:00AM to 09.05.2012 07:00AM

In cell A1: 08.05.2012
In cell A2: 09.05.2012

JBeaucaire
May 10, 2012, 07:39 AM
I've read that 3 times and still don't see what you're saying differently. Time to show me.

Click GO ADVANCED and use the paperclip icon to post up a copy of your workbook. Make sure the workbook demonstrates your desired results if possible, or just highlight the cells you're trying to fix. Use BEFORE/AFTER sheets if that helps make it clearer.

TitoTito
May 11, 2012, 06:43 AM
See an example, please.

JBeaucaire
May 11, 2012, 10:18 PM
Formulas...

A1: =IF(HOUR(NOW())<=6, TODAY()-1, TODAY())
A2: =IF(HOUR(NOW())<=6, TODAY(), TODAY()+1)

TitoTito
May 12, 2012, 12:23 AM
It seems that this is it.

Merci beaucoup

JBeaucaire
May 12, 2012, 07:58 PM
It just occurred to me that you don't need that fancy A2 formula, just use:

=A1+1