Results 1 to 2 of 2

Thread: Help with day of year

  1. #1
    Neophyte Houston.Brown's Avatar
    Join Date
    Jan 2017
    Posts
    4
    Articles
    0
    Excel Version
    Excel for mac 2011

    Help with day of year



    Register for a FREE account, and/
    or Log in to avoid these ads!

    What I'm trying to do seems to be pretty straightforward but I cannot figure out how to get the day of year correct. My research has shown me this formula over and over =DATE(year(A2),1,0) but it does not seem to work. It does not return a Number but instead returns a date.

    I am simply wanting to take a dollar amount and divide it by the day of year in order to get an average spending amount per day. This formula does not work but this is what I am trying to do.

    Cell K18 has a year to date dollar value lets say 450
    In cell K20 I want to display a number that is "450 / (day of year)" to give me an daily spending rate. Simple.

    Can not get this to work.

    What should the formula look like?

  2. #2
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,364
    Articles
    0
    Excel Version
    Office 365 Subscription
    Try this:

    =TODAY()-DATE(YEAR(A2),1,1)+1
    Ali
    Enthusiastic self-taught user of MS Excel!

Posting Permissions

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