Results 1 to 2 of 2

Thread: Date formulas
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Feb 2014
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Date formulas

    I am having a hard time figuring this out please help...

    I have four cells:
    one cell uses a manual date entry we will call that one a1
    The second cell uses a formula to input current date a2 =sum(today())
    Third cell uses a formula to figure the days between the two dates and adds 1 =sum(a2-a1+1)
    I want to set up the fourth cell so that my workers can enter a y and it will stop a2 at the current day its on basically date stamp it. Can I do this and if so can someone help me with the formula I would use?

    Thank you for your help!

  2. #2
    Board Regular etaf's Avatar
    Join Date
    Oct 2012
    Location
    UK, West Sussex
    Posts
    3,379
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Date formulas

    you can use a datestamp formula - which uses circular reference - but could give you other issues ,if you do have unintentional circular reference

    have a read of these two sites - for setting a time/date stamp

    Create A Timestamp In Excel With Formulas
    How to insert timestamps in excel sheet using formulas | Chandoo.org - Learn Microsoft Excel Online
    Wayne

    Using Excel Version 365 for Mac

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •