Displaying a date as text

		Microsoft Office Forums > Microsoft Excel > Excel
Displaying a date as text

01-07-2011, 01:43 PM

macropod

Windows 7 32bit Displaying a date as text

Office 2000

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,467

Hi Mandusin,

The formula for C6 is:
=INT(TODAY()/7)*7+2
The formula for C13 is:
=INT(TODAY()/7)*7+3
and so on.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Graphs: how to stop displaying a value	thorgal67	Excel	2	12-17-2010 07:59 AM
Anyway to determine time/date of text creation?	pureride	Word	1	01-05-2010 02:09 PM
help to convert swf to avi for displaying in ppt?	Frederick	PowerPoint	1	09-13-2009 08:10 PM
new appointment date always reverts back to today's date	msills	Outlook	0	08-24-2007 08:57 AM
Imported message date change to today's date	promark	Outlook	1	12-23-2005 07:21 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:36 PM.