View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default I want to add 6 months to a certain date in a formula (Excel)

One way.
With starting date in A1, try this:

=DATE(YEAR(A1),MONTH(A1)+6,DAY(A1))
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"Joana" wrote in message
...
I need to calculate 6 months (for example) starting from a certain date (not
TODAY)...