View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Louise Louise is offline
external usenet poster
 
Posts: 217
Default calculate prior calendar year end from a moving current date

I need to calulate the prior calendar year end date based on a moving date.

can anyone help?

example: 09-30-06 prior year date = 12-31-05

the 09-30-06 changes


Louise