Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom 4 week periods
I have the need to calculate 4 weekly periods with the periods starting on a
Thursday (historical reasoning) as follows: Period 1 Start-29th May End-25th June Period 2 Start-26th June End-23rd July I have found out how to do this with Access but the same functions are not available in Excel Many thanks in advance |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom 4 week periods
My Mistake
Periods run from a Friday not a Thursday "dazza_dog" wrote: I have the need to calculate 4 weekly periods with the periods starting on a Thursday (historical reasoning) as follows: Period 1 Start-29th May End-25th June Period 2 Start-26th June End-23rd July I have found out how to do this with Access but the same functions are not available in Excel Many thanks in advance |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom 4 week periods
You say you want to calculate 4 week periods. I'm not sure what that means, you just want a list? If you put the start date of period 1 in B2, i.e. 29-May-2009 then C2 will calculate the end date with the formula =B2+27 then in B3 you can use the formula =B2+28 and then copy that formula across to C3 and down both columns as far as you need. Format all cells in the required date format -- barry houdini ------------------------------------------------------------------------ barry houdini's Profile: http://www.thecodecage.com/forumz/member.php?userid=72 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=108599 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Generate list of dates for 4-week periods | Excel Discussion (Misc queries) | |||
Special custom fill function which adds periods at the end of text | Excel Discussion (Misc queries) | |||
HOW to calculate the interest paid between 2 custom periods? | Excel Worksheet Functions | |||
Custom Date format ie. 01.01.05 W1 (W1 is week 1) | Excel Discussion (Misc queries) | |||
How do I make a Custom Datre Format ie 01.01.05 WK1 (WK is Week 1) sorry about previous post | Excel Discussion (Misc queries) |