function

[samyo]

hi:

anybody can help me solve the problem


how to convert date to yesterday date if the time is before 7:00:00 AM

for example
12-11-2003 2:30:00 AM ----translate to --------11-11-2003
(sample data)confused

 

[Jason Morin]

Try:

=IF(7<HOUR(G6)+MINUTE(G6)/60,G6-1,G6)

HTH
Jason
Atlanta, GA

-----Original Message-----

hi:

anybody can help me solve the problem


how to convert date to yesterday date if the time is before 7:00:00 AM

for example
12-11-2003 2:30:00 AM ----translate to --------11-11- 2003
(sample data)confused:


------------------------------------------------
[/url]
~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step

guide to creating financial statements

 

[Jason Morin]

Oops...change the "<" to ">".

Jason

-----Original Message-----
Try:

=IF(7<HOUR(G6)+MINUTE(G6)/60,G6-1,G6)

HTH
Jason
Atlanta, GA

-----Original Message-----

hi:

anybody can help me solve the problem


how to convert date to yesterday date if the time is before 7:00:00 AM

for example
12-11-2003 2:30:00 AM ----translate to --------11-11- 2003
(sample data)confused:


------------------------------------------------
[/url]
~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by

step
guide to creating financial statements

.

.