due dates
Take a look at Excel Help for the EOMONTH() worksheet function. It is part
of the Analysis ToolPak add-in in pre-2007 versions of Excel, so you may need
to install that before the function is available to you.
"GAIDEN" wrote:
Is there a formula that can calculate future monthly and semi monthly due
dates correctly.
Example: 05-31-2009 + ???? = 06-30-2009 + ???? = 07-31-2009
Example: 05-16-2009 + ???? = 05-31-2009 + ???? = 06-16-2009 + ???? =
06-30-2009
|