Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
back date calculation?
I would like to find out what each entry date would be if I had a
global start date, each entry had a day count and the result would be a backwards calendar count Example: If my global date was May, 30, 2006 (05/30/2006) I had an entry which the day count was 42 The answer for that entry would be the date (MM/DD/YYYY) 42 days before the global date Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
back date calculation?
With your global date in A1 put 42 in B1 in C1 put =A1-B1, will this do what
you want to? -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 wrote in message ups.com... I would like to find out what each entry date would be if I had a global start date, each entry had a day count and the result would be a backwards calendar count Example: If my global date was May, 30, 2006 (05/30/2006) I had an entry which the day count was 42 The answer for that entry would be the date (MM/DD/YYYY) 42 days before the global date Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Set a date as a constant to work back from to show only weekdays | Excel Discussion (Misc queries) | |||
Set a date as a constant to work back from to show only weekdays | Excel Discussion (Misc queries) | |||
Timesheet Date Calculation | Excel Worksheet Functions | |||
Quick date calculation functions | Excel Worksheet Functions | |||
Date issue between Windows and Macintosh version | Excel Discussion (Misc queries) |