Change to formula

[bbc1]

Hi I am using this formula to return a date when spreadsheet is altered, I
require the date to ne one day less than the present day. Ie is the actual
date is 6/6/08 need it to return the 5/6/08
=IF(AND(B6="",B4<>""),NOW(),IF(AND(B4<>"",B6<>""),B6,""))
any help would be greatly appreaciated.

 

[Rick Rothstein \(MVP - VB\)]

Since the non-time portions are day offsets from some starting time, just
subtract 1 from the date and you will have the day before's date...

=IF(AND(B6="",B4<>""),NOW()-1,IF(AND(B4<>"",B6<>""),B6,""))

By the way, if you only need the date, without the time portion, you can use
the TODAY() function in place of the NOW() function.

Rick

 

[Bernard Liengme]

Have you tried replacing NOW() by TODAY() - 1 ?
best wishes