Thread: How to I calculate 180 days from any date?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme Bernard Liengme is offline
external usenet poster
  
Posts: 4,393
Default How to I calculate 180 days from any date?
=A1+180
Format as date (if needed)
Excel stores dates as serial numbers starting with 1/1/1900 as zero
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Jackie" wrote in message
...



Reply With QuoteReply With Quote