Inserting date range in a cell?

**spav** · 04-03-2012, 12:19 PM

Does anyone know how to insert a date range in a cell that is based on your computers clock. I want to use something like the =today() function, but I want it to be for the current week. Any ideas, or is this not possible?
Thanks

**Søren Larsen** · 04-03-2012, 12:50 PM

Can you use =WEEKNUM(TODAY()) ?

Or is that not what you are looking for?

**Søren Larsen** · 04-03-2012, 01:03 PM

Actually, perhaps you were looking for this:

Start date (monday): =(TODAY())-WEEKDAY((TODAY()),1)+2

End date (sunday): ="Start data"+6

**icestationzbra** · 04-03-2012, 01:04 PM

if your date, for e.g., TODAY(), is in K21, following could be in L21:

=TEXT((K21-WEEKDAY(K21)+1),"dd-mmm-yy")&" to "&TEXT((K21+7-WEEKDAY(K21)),"dd-mmm-yy")

this would display '01-Apr-12 to 07-Apr-12' in L21.

or perhaps a little more dynamic:

=TEXT((TODAY()-WEEKDAY(TODAY())+1),"dd-mmm-yy")&" to "&TEXT((TODAY()+7-WEEKDAY(TODAY())),"dd-mmm-yy")

is this what you are looking for?