HI all,
Please could you help me I've got a spreadsheet with the following formulas that I want to implement:
=INT((TODAY()-E2)/7))
=IF(ISBLANK(E2),""
=IF (L2=”ARRIVED”, "",
Basically, I want the cell to calculate how many weeks between today and the date in cell E2. If cell E2 is blank, then I want the current cell to stay blank. ALSO, if cell L2 has the word "ARRIVED", then I want the cell to stay blank. How do I combine all 3 formula's into one cell?
Would really appreciate your help! THanks!
Bookmarks