Hi, I have a date question was trying 2 ask, 2 posts down, getting a feel of
what to ask.. don't get date functions too much.
How do you backward / forward find date serial for 1900 system, to figure
equations (maybe just plug into a cell, see what it says: struggling with
that too.

Equation Looking for: How do I determine if date in a cell is 1 day old.
Thanks.

Something like: ?
=IF(DATE(DAY(A1)+1<DATE(TODAY(A1)),true,false) guessing something like this



"Sandy Mann" wrote:

Chris,

If I understand you correctly, try:

=DATE(YEAR(D3)+(D3=33239)*2+3,MONTH(D3),DAY(D3))

(33239 is the "Day No" of 1/1/91)

--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk