date formulas
Posted by Irby Johnson on January 10, 2002 2:27 PM
I am setting up a spreadsheet with a due date at the end of each month. Is there a way where I can create a formula that will automatically set the date of each month? Right now my formula only allows me to add a certain number of days. I would be very appreciative if someone could help me out.
Posted by Fleance on January 10, 2002 2:37 PM
Look at EOMONTH and EDATE worksheet functions.
Posted by IML on January 10, 2002 2:41 PM
You could also use
=DATE(YEAR(A1),MONTH(A1)+1,0)
where the date of interest is in A1. this way you don't need to worry about installing the analysis tool pak (although there are some great functions in there.)
