• 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.

past date formula

S

saneesh

New Member
how to get a decimal figure by subtracting two past date(not current date)..


ie;07(month)/08(date)/2011(year)-07(Month)/23(Date)/2011(Year)=answer 15(means the gap between the past 2 days.
 
Saneesh,


Welcome to Chandoo_Org Forums.


Try =INT(Firstdate - SecondDate)


I hope this is what you were looking for...


~VijaySharma
 
You must log in or register to reply here.
Back
Top