Thread: due dates
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default due dates

Hi,

We failed to mention that these two functions are part of the Analysis
ToolPak in 2003 and earlier although they are part of Excel in 2007. You
must attach the above add-in by choosing Tools, Add-ins, and checking
Analysis ToolPak.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"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