Date & Time Return a Date

[shonaart]

Hi
Column A = I have a Date & Time ( 2011/06/14 13:15 ) etc
Column B = I want the formula to look at Column A and return a Date. ( 2011/06/14 )

Here is the catch , a normal day , runs from 12 at night to 12 the following night.
I want my day to run from 06H00 to 05H59 the next day.
Therefore the 14th of June will be from the 2011/06/14 06:00 to 2011/06/15 05:59 .

The 2011/06/15 = 2011/06/15 06:00 to 2011/06/16 05:59

The date that must return is in this format 2011/06/15

pls help

Thanks
Vaughan

 

[Comfy]

Try:

=IF(MOD(A1,1)<0.249305555553293,INT(A1)-1,A1)

Cell formatted as yyyy/mm/dd

/Comfy

 

[shonaart]

HI Comfy,
You a master, thank you