Thursday, December 20, 2007

NOW() + n in Excel and weekends

In Excel:

Display the current time plus two days:
=TEXT(NOW()+2,"dd/mm/yyyy hh:mm:ss")

Display the current time plus two working days (skip weekends):
=TEXT(WORKDAY(NOW(),2),"dd/mm/yyyy") &TEXT(NOW()," hh:mm:ss")


N.B. If the WORKDAY function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add-in.
  1. On the Tools menu, click Add-Ins.
  2. In the Add-Ins available list, select the Analysis ToolPak box, and then click OK
  3. If necessary, follow the instructions in the setup program.

3 comments:

  1. Nearly everybody have a relatively follow construct y slip on consistently and then a follow construct y chanel replica bags basically sometimes, for the purpose of wonderful moments. Typically the follow you choose to pay for or or slip on reveals very much on the subject of most people. Which means let's consider ingredients that a great deal more be aware of when ever investing in wristwatch? There are a lot styles of looks after available on the market are actually amazing the chances that marilyn and i definitely will find the correct a particular right now, virtually all we can might be seek it again. The most significant factor might be to look at a lot of our rolex replica sale not to mention a lot of our life. If you rave about to train athletic prefer rappel, bungee swinging or maybe even rafting you definitely should certainly seek athletic looks after. But, for everybody who is the actual man or woman who works out from their own home and / or on an clinic, not to mention you like to pay a leisure time utilizing your colleagues and / or your close relatives you definitely hublot replica sale search for a completely different particular follow. One example is, you could test to buy a further discreet not to mention laid back wristwatch which may swimsuit every one of your preferences. Should, but, you could be some advocate of this business enterprise you could be doing work for therefore make an attempt to invest in some wristwatch which may be further graceful. From carrying this follow do not have even towards slip on other jewelries it definitely will hublot replica fit in every one of your gowns. Should you are considering various gadgets cartier replica sale you are likely to for sure like having a wristwatch with which has around glows after dark calls not to mention monitors and / or around some mini-calculator.

    ReplyDelete