View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default count a number of days from a date

On Thu, 4 Dec 2008 09:59:01 -0800, RGlade
wrote:

I need to know the formula for: counting the number of days from a certain
date

So, example. I need to know what date is 270 days from July 1, 2008.

Thank you.


With July 1, 2008 in A1, the date 270 days later:

=A1 + 270

Format as a date.
--ron