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.
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.
I still need help!
Hi Zoe,
Let split on two parts. First one returns fired day or today if fired day is empty, assuming you have them in column B
=IF(ISBLANK(B2),TODAY(),B2)
If hiring days in column A when number of weeks between these two days will be
=ROUNDUP((IF(ISBLANK(B2),TODAY(),B2)-A2)/7,0)
I'm sorry for previous formula, weeknum returns the week number within the year, it'l be simply to use your ROUNDUP