Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Dates
Can any one advise me on the following.
How do I create a simple spreadsheet to return dates from a set criteria. Example I want to enter a start date, then the number of weeks of the period (i.e 26weeks) This will return a date DD/MM/YY I wouldalso like to be able to enter a offset figure of +/- 1,2, or 3 ....days The offset criteria providing me with the date I want. For Example Date DD/MM/YY - 1 day ....etc or Date DD/MM/YY + 1 day.....etc Question The offset I could possible select from say a validation list? Taking the spreadsheet a little further How would I incorporate the periods in Weeks / Months / Years For Example Select Period from a Validation list....weeks or Months or Years Enter a Start Date Enter Number of Weeks / Months or Years I want to count ahead Enter the offset number......the criteria to provide the date I want. Any help would be great Even if anyone can provide a sample .Xls that I could study would be fantastic. Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Identifying unique dates in a range of cells containing dates... | Excel Discussion (Misc queries) | |||
Identifying unique dates within a range of cells containing dates | Excel Discussion (Misc queries) | |||
need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
How do I get the dates on an excel chart to stay as dates instead. | Charts and Charting in Excel | |||
Charting data against dates where dates are not at fixed intervals | Charts and Charting in Excel |