View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Calculate eligibility/enrollment date

In which case, use 89 rather than 90.

In article ,
Shane Devenshire wrote:

Hi,

Just a little warning, if you are elegible at 90 days not after 90 days then
you had better revisit JE's formula for a date link January 2, 2008. It will
return 7/1/08 when it should return 4/1/08.