Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to count number of days between 2 dates? | Excel Discussion (Misc queries) | |||
Formula to count number of sequential days in a row | Excel Worksheet Functions | |||
Count number of days between dates BUT IF null to current date | Excel Worksheet Functions | |||
How do I count the number of days from 1 date to another? | Excel Discussion (Misc queries) | |||
Count number of days in given month? | Excel Worksheet Functions |