DiscussWorldIssues - Socio-Economic Religion and Political Uncensored Debate - View Single Post

**Viyzarei** · 01-13-2012, 07:28 AM

I'm not sure if Excel supports this syntax, but you need something like:

IF(MOD(TODAY()-N4,7)=0 OR TODAY() = '1 jan 2012',TODAY()

This should encapsulate it (I wrote it in the reply rather than in a spreadsheet so there might not be enough brackets) if it's required.
Code:

Code

=IF(OR(DATE(2012,1,1)=TODAY(),MOD(TODAY()-N4,7)=0),TODAY(),"Whatever you want this to be if it isn't a 7 day multiple")

01-13-2012, 07:28 AM	#8
Viyzarei Join Date Oct 2005 Posts 404 Senior Member	I'm not sure if Excel supports this syntax, but you need something like: IF(MOD(TODAY()-N4,7)=0 OR TODAY() = '1 jan 2012',TODAY() This should encapsulate it (I wrote it in the reply rather than in a spreadsheet so there might not be enough brackets) if it's required. Code: Code =IF(OR(DATE(2012,1,1)=TODAY(),MOD(TODAY()-N4,7)=0),TODAY(),"Whatever you want this to be if it isn't a 7 day multiple")
	Quote