About Edate


September 2nd, 2011 by admin admin
Question: We use edate function for finding the date after  certain months .do we have similar functions for years and days?
 
Answer: As far as we know, edate is the only function in Excel. For years, we always multiple the number of years by 12. EYear is not really necessary because the number of days is consistent for the months in every year except Feb. There is no need for days, just add the number of days to the start date.

Leave a Reply

You must be logged in to post a comment.

s2Member®