WEEKNUM function not adhering to the IF statement

		Microsoft Office Forums > Microsoft Excel > Excel
WEEKNUM function not adhering to the IF statement

FAQ

Thread Tools

Display Modes

06-09-2016, 06:28 AM

Pecoflyer

Windows 7 64bit WEEKNUM function not adhering to the IF statement

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,943

Pecoflyer has a reputation beyond repute

Why not =text(weeknum(your-date),"00")

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Tags

error, formula, formula help

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Restrict Editing function disable insert textbox function	IanM_01	Word	5	11-21-2015 02:29 AM
formula needed to sum weeknum results from multiple worksheets	JOJO101	Excel	0	06-27-2015 11:06 PM
#REF! Error in calling VBA function disappears when function is copied	lcaretto	Excel Programming	2	05-26-2014 07:19 PM
Using WEEKNUM to calculate how many weeks from date to today.	stephen_	Excel	1	07-02-2013 06:41 AM
Mail Merge Function not Noticing 'True' vs. 'False' Statement	danellekent	Mail Merge	1	04-27-2012 02:19 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:02 PM.