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
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.
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:
- Spreadsheet
- Google spreadsheet right to left - Guide
- Formula spreadsheet definition - Guide
- Spreadsheet screenshot - Guide
- How to password protect open office spreadsheet - Guide
- How do i change the author of an excel spreadsheet - Guide
1 response
mubashir aziz
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
166
May 19, 2009 at 02:44 AM
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
=IF(WEEKDAY(TODAY(),2)=2,TODAY(),"")
For your information
1 is for Monday , 2 for Tuesday and onward 7 for Sunday