• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Date Calculation

T

Thomas Kuriakose

Active Member
Respected Sirs,

I came across the below function for a date calculation.

=IF(OR(E2>1000,C2>1,D2>1000),0,IF(F2>1000,F2+2,G2+2))

Kindly let me know why >1000, <1000 is used with reference to the date.

Thank you very much,

with regards,
thomas
 

Attachments

  • Date Calculation.xlsx
    10.4 KB · Views: 3
Well if you add 1000 days to 00/00/1900 you get 26/09/1902, so it's got something to do with that.........what that is.......your guess is as good as mine.
 
It was written by Henry VIII to calculate when he figured he'd have enough of Anne Boleyn - alas, he hadn't realized that Excel dates started in 01/01/1900, and not in 1536 ...


Seriously, I think it's just a placeholder - stick any value in there, to see if it will work, and I'll return later and expand on it ...
 
You must log in or register to reply here.
Back
Top