Previous Topic Next Topic

Spreadsheet

Closed
Appatight - 17 May 2009 à 17:03
mubashir aziz Posts 190 Registration date Sunday 12 April 2009 Status Member Last seen 16 February 2010 - 19 May 2009 à 02:44
Hello,

I'm currently working on a spreadsheet for a timesheet. I want to format a cell to display the date of a certain day of the week. e.g. I would cell B20 to only display the date of Monday for the current week that the sheet is opened. If it the current week is 5/11 - 5/17 and I want B20 to only display the date for Wednesdays so cell B20 should display 5/13. Is this possible? Even if I open the sheet on the Friday I still want B20 to display the date for Wednesday. All help would be greatly appreciated.
Related:

1 response

Réponse 1 / 1
mubashir aziz Posts 190 Registration date Sunday 12 April 2009 Status Member Last seen 16 February 2010 166
19 May 2009 à 02:44
Just write this formula in any cell and if today is Tuesday ........ this is an idea and you can apply any where and even instead of today() function you can give reference of cell ......

=IF(WEEKDAY(TODAY(),2)=2,TODAY(),"")

For your information

1 is for Monday , 2 for Tuesday and onward 7 for Sunday


Similar discussions

Creating A Summary Sheet
BuckeyeJR -
vcoolio -

1 response
Transfer, populate and calculate data between excel sheets.
D Kos -
rizvisa1 -

1 response