View Full Version : Help to generate week ending from days as per financial new

09-07-2011, 06:52 AM
Hi All,

Is there a way to determine the week ending and set same to the date as per the start of a financial calender year and it continue to place the define week ending until the next monday.

see attached file for better idea.

for example

date : 3-07 it place the defined week ending of 03-07
date : 04-07 it place the defined week endinf of 03-07
thhis continues until the next Sunday and on Monday the week ending becomes 10-07.

i have give it many tries till now and is still struglling with.

Many thanks for any help on that.

09-07-2011, 08:11 AM

Is the attached something like what you were wanting?

09-07-2011, 08:39 AM
Try this formula


09-07-2011, 09:47 PM
Hi Apps / Bob,

Many thanks for the help . Ya its like this that i wanted to have the week being display Apps.

Thanks again.