Spreadsheet

Closed
Appatight - May 17, 2009 at 05:03 PM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - May 19, 2009 at 02:44 AM
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.

1 response

mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 165
May 19, 2009 at 02:44 AM
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


0