I need to enable the following formulas in some boxes:
1. Put two formulas: the HOY (today) function to automatically take the date + take a manually written static time (Registered date cell and Updated date cell)
2. In the box next to it, take the same date and one more time than the one you put in the previous one, automatically (Next query available date on the map cell)
3. I have a formula of random numbers between 1 and 3, if in another cell it puts 0, indicate that it must always be 3 (Total queries on the map cell is aleatory and Remaining queries on the map cell when if it's 0 have to be 3)
24 freelanceria on tarjonnut keskimäärin €24 tähän työhön
I use excel in my day to day life and I am comfortable with the formulas and analysis in excel. I am confident to complete the project in given timeline.
I am a working professional in the domain of finance and accounting which involves a lot of work on Microsoft excel which makes me the best candidate for this project.