ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   count a number of days from a date (https://www.excelbanter.com/excel-discussion-misc-queries/212504-count-number-days-date.html)

RGlade

count a number of days from a date
 
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.

Ron Rosenfeld

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

Peo Sjoblom[_2_]

count a number of days from a date
 
Just add, date in A1

=A1+270

format as date

--


Regards,


Peo Sjoblom

"RGlade" wrote in message
...
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.




RGlade

count a number of days from a date
 
Thank you so much. And for the quick turnaround. Appreciate it.

"Peo Sjoblom" wrote:

Just add, date in A1

=A1+270

format as date

--


Regards,


Peo Sjoblom

"RGlade" wrote in message
...
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.






All times are GMT +1. The time now is 01:09 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com