| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
What date is7 days from given date in Excel 2000
That seems to work also. Since I want to have both a column with the date and
a column with the day of week, I can just make a copy of the date column and change the format to 'ddd'. Thanks again "Bernard Liengme" wrote: If the cell holds a date, why not use a custom format of 'ddd' or 'dddd' to get Mon or Monday -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "GregNga" wrote in message ... Thanks to you both, I guess that was too obvious. One other question: Is there a way to have a cell equal to the day of the week in format MON, TUE, WED, etc based on the date in another cell. I know WEEKDAY(A1) will give it in format 1,2,4 but I would like MON, TUE, WED format, thanks "Bernard Liengme" wrote: Regardless of Excel version: =A2+7 and format as date If you meant 7 workdays: =WORKDAYS(A1,7) best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "GregNga" wrote in message ... In Excel 2000, how can I calculate cell A9 to be 7 days from the A2 I am now using Excel 2000 where I work and I have been used to doing this in Excel 2003 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
| Excel Formula to calulate number of days passed from date to date | Excel Discussion (Misc queries) | |||
| Can Excel add working days to a date to result in another date? | Excel Worksheet Functions | |||
| In excel,how do I change the date to a date 84 days from previous | Excel Discussion (Misc queries) | |||
| How do I sort by date (not days, weeks, months) in Excel 2000? | Excel Discussion (Misc queries) | |||
Threaded Mode
