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. |
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 |
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. |
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