Date formula question

**fess332** · 10-15-2012, 07:51 AM

I am trying to make excel show a specific day/date of the week in a cell. For example I always want the next Tuesday's date to show in a cell, or if today is Tuesday then I want it to show today. Any one know how I might do this?

thanks in advance

**dilipandey** · 10-15-2012, 08:41 AM

Hi fess332,

Try using belwo formula :-

Formula:

Please Login or Register  to view this content.

where a1 is the cell where you'll enter your dates. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

**fess332** · 10-15-2012, 08:56 AM

Hmm, it works, but i am wondering will it return the correct date tomorrow, I tried using this instead

=TODAY()-WEEKDAY(TODAY(),13)+7

**dilipandey** · 10-15-2012, 09:02 AM

Yes.. it should give.

I have checked this with a full week's dates. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

**daddylonglegs** · 10-15-2012, 01:47 PM

You can whether or not it will work for tomorrow or the day after. Just use the original formula suggested by dilipandey and try different dates in A1, note that option with WEEKDAY isn't available in earlier excel versions, so this version will work for those

=A1-WEEKDAY(A1-3)+7