Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate Start Date
Hello,
I would like to specify a date range for a report where the end date is today (using =TODAY() in this cell) and the start date is today minus 14 days (or 10 working days). My goal is to have both dates appear correctly in a report template. I found reference to an EDATE function that works well to subtract months from TODAY. Is there a similar function to subtract days, or if not is there another way to do this? Thanks, Tom |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate working hours from a start and finish time over several | Excel Worksheet Functions | |||
Calculate Start Dates based on Need-By Date? | Excel Worksheet Functions | |||
Calculating Difference Between Start Date & Time And End Date & Ti | Excel Discussion (Misc queries) | |||
how do I do a Planned vs Actual start date & end date graph | Charts and Charting in Excel | |||
calculate weeks from a start date ( not yr weeks) | Excel Worksheet Functions |