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

In cell A1: =TODAY() (formatted to display as you want)
In cell A2: =TODAY() + 1 (formatted to display as you want)

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

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.

See an example, please.

Formulas...

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

It seems that this is it.

Merci beaucoup

It just occurred to me that you don't need that fancy A2 formula, just use:

=A1+1