Forum Discussion
Solved
IF FUNCTION AND ROUNDUP
I have a current formula - =ROUNDUP(($A$1-J18)/7,0) This tells me how many weeks have past from one date to another. What I want to add is that if another cell has a date in it that has pass...
When it's something like this
=WEEKNUM(IF(ISBLANK(<hired off date>),TODAY(), <hired off date>)) - WEEKNUM(<hired on date>)
Perhaps plus 1 depends on how do you calculte not full week, as zero or as 1.
Can you please rephrase that or give us a more complete insight in your problem? What other cell, with what date do you compare (today?), what is summed up? As hard as I try I have Problems finding out your needs.