Spreadsheet [Closed]

Report
-
Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
-
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 reply

Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
215
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


Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!