|  | Change to formula | | |
| | | bbc1 |  |
|  Posted: Tue Jun 03, 2008 11:29 am Post subject: Change to formula |  |
I am using this formula to display the current date on a sheet, I require it
to show the actual day before, what do I need to change.
=IF(AND(B6="",B4<>""),NOW(),IF(AND(B4<>"",B6<>""),B6,"")) |
| |
| | | Bob Phillips | |
| | Posted: Tue Jun 03, 2008 11:47 am Post subject: Re: Change to formula | |
=IF(AND(B6="",B4<>""),TODAY()-1,IF(AND(B4<>"",B6<>""),B6,""))
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"bbc1" <bbc1@discussions.microsoft.com> wrote in message
news:9F920C16-159A-478D-AEC3-81BD6ABC5977@microsoft.com...
| Quote: | I am using this formula to display the current date on a sheet, I require
it
to show the actual day before, what do I need to change.
=IF(AND(B6="",B4<>""),NOW(),IF(AND(B4<>"",B6<>""),B6,"")) |
|
| |
| | | edvwvw via OfficeKB.com | |
| | Posted: Tue Jun 03, 2008 11:51 am Post subject: Re: Change to formula | |
bbc1 wrote:
| Quote: | I am using this formula to display the current date on a sheet, I require it
to show the actual day before, what do I need to change.
=IF(AND(B6="",B4<>""),NOW(),IF(AND(B4<>"",B6<>""),B6,""))
|
try amending as follows:
| Quote: | =IF(AND(B6="",B4<>""),NOW()-1,IF(AND(B4<>"",B6<>""),B6,""))
|
I presume that you are checking if there is a value in B4 , if so then put
yesterday's date. If there is a value in B6 put in whatever is in B6 .
Finally if B4 B6 are empty then leave blank.
edvwvw
--
Message posted via OfficeKB.com
LINK |
| |
| | | bbc1 | |
| | Posted: Fri Jun 06, 2008 12:05 am Post subject: Re: Change to formula | |
Thankyou if works
"Bob Phillips" wrote:
| Quote: | =IF(AND(B6="",B4<>""),TODAY()-1,IF(AND(B4<>"",B6<>""),B6,""))
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"bbc1" <bbc1@discussions.microsoft.com> wrote in message
news:9F920C16-159A-478D-AEC3-81BD6ABC5977@microsoft.com...
I am using this formula to display the current date on a sheet, I require
it
to show the actual day before, what do I need to change.
=IF(AND(B6="",B4<>""),NOW(),IF(AND(B4<>"",B6<>""),B6,""))
|
|
| |
|
|
