Thread: Date
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default Date

Try this:

=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1)+2)

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"robzrob" wrote in message
ups.com...
Hello All

New to this, so this question may have been answered before - don't
know.

I want to be able to add one calendar month and then 2 days to any
date. Any ideas?

Thanks

R