Question: How do I automatically create a list of working days from one date to another? I want to make a range of dates from 8/31/11 thru 3/1/2012, for example. I want to have the dates listed in a column.
Answer: You can use the Workday formula WORKDAY(start_date,days,holidays)
Friday, September 02, 2011
About Edate
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.
Subscribe to:
Posts (Atom)