| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculate a date, 10 weeks after a set date
I have a series of given dates in column 1; which formula should I use to
calculate automatically the dates, 10 weeks later, in column 2 -- Guido |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
calculate a date, 10 weeks after a set date
Since XL dates are just integer offsets from a base date:
A1: <date B1: =A1+70 Format B1 as a date. In article , Guido Cole wrote: I have a series of given dates in column 1; which formula should I use to calculate automatically the dates, 10 weeks later, in column 2 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
calculate a date, 10 weeks after a set date
Hi!
Just add 70: A1 = some date B1 = =A1+70 Biff "Guido Cole" wrote in message ... I have a series of given dates in column 1; which formula should I use to calculate automatically the dates, 10 weeks later, in column 2 -- Guido |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate A Date Excluding Weekends And Holidays | New Users to Excel | |||
| Calculate A Date Excluding Weekends And Holidays | New Users to Excel | |||
| calculate percent met (comparing 2 date columns) | Excel Worksheet Functions | |||
| calculate the number of days from date received | Excel Worksheet Functions | |||
| How do I automatically calculate YTD numbers by changing a date? | Excel Worksheet Functions | |||
Hybrid Mode
