Formulae: Calculating Week Start - Week Ending dates?

Panos · September 17, 2014 1:48PM

Hi
Is there any formula so I can get the "week start" or "week end" for each week number?
Regards,
Panos

paola · September 17, 2014 2:20PM

BUCKET([Date], 1, "week", "dd MMM yyyy")
This formula can be used for output format like:
26 Dec 2011 to 02 Jan 2012

If the default week start/end dates do not fit with your company/industry - please see the Regional date settings, as these can be customised.
Settings>Advanced file settings>Regional

Using the same principle, you could create a new field [Week commencing], adding one more step.

Welcome!

Categories

Ideas Parade

Tagged