Easily see your job accurately, In the event the formula will help resolve your condition: =IF(B1=””,TODAY()-A1,B1-A1) Promise here’s what you would like
Hi Alexander, It truly does work very well depending on my personal requirements. Thanks considerably and you may take pleasure in your fast effect. Thank you so much again.
Good morning, I’ve an excellent COUNTIF algorithm so you can number exactly how many moments employees are booked attend training in a romantic date diversity. This new formula I use is fe =COUNTIF(Table[, ]], ‘TRAINING”) Currently I must yourself alter the current big date every day. Could there be an easy way to revision Wednesday, to the current time informal? The education classification is only one away from 57 groups that We currently improve manually.
Hi! It is extremely difficult to see an algorithm with unique records to the workbook worksheets. So you can input most recent big date, play with Today setting, because described more than.
Hello Alexander, Thanks for your effect. I did choose the fresh new Now form and today setting however, it did not works. The fresh new spreadsheet that we have always been using has the times into the line 1 in long date style. Line A has a listing of whenever 500 teams. Just like the weeks continue it is important for me to remain switching the initial day regarding reference to the current schedule big date to make certain that We only show the latest scheduled Knowledge schedules to possess tomorrow. Leia mais