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.
Configuration: Windows XP Internet Explorer 6.0
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 ......
|
Automatic interface between spreadsheets Automatically copy a column from an excel spreadsheet into a new Basic spreadsheet functions Batch file copy cells within excel from one spreadsheet to another Excel searching in multiple spreadsheet Excel spreadsheet percentage calculation Excel spreadsheet to tom tom 720 How to add data form different spreadsheets How to get the value in the last cell in any spreadsheet Nokia 5310 spreadsheet softwares free download Ntroduction of excel spreadsheet Referencing excel spreadsheet in word macro Sharing excel spreadsheets between office 2007 and office 2003 Spreadsheet count number of rows containing string Spreadsheet formulas Use macro to copy column of data from one spreadsheet to another Vba update spreadsheet only if certain cells change What is a range of cells in a spreadsheet