| Home |
| Search |
| Today's Posts |
|
#13
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need to convert list of dates to count no. of dates by week
And depending on what should happen to the Saturday following that Friday:
=A1+6-MOD(A1,7) Bob Phillips wrote: =A1+(6-WEEKDAY(A1)) gets the Friday the date in A1 -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "neowok" wrote in message ... hmmm i think that would work better. how would i get the date of the friday in that week? because i would need those dates anyway as the axis labels. -- neowok ------------------------------------------------------------------------ neowok's Profile: http://www.excelforum.com/member.php...fo&userid=5940 View this thread: http://www.excelforum.com/showthread...hreadid=505716 -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count No. of times Dates are repeated | Excel Discussion (Misc queries) | |||
| count date occurances in range of dates... | Excel Worksheet Functions | |||
| user defined function | Excel Worksheet Functions | |||
| have dates entered from a list of data into an excel template | Excel Discussion (Misc queries) | |||
| I have a list of dates that I need to count based on a date range | Excel Worksheet Functions | |||
Threaded Mode
