Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
Solved

# Calculate days from beggining of year

Posted on 2014-01-27
Medium Priority
237 Views
Hi,

Can someone give me some formula that will calculate how many days from the beggining of the year, something like

today()-01/01/2014

Many thanks
0
Question by:Seamus2626
• 2

LVL 143

Accepted Solution

Guy Hengel [angelIII / a3] earned 1000 total points
ID: 39811602
this should do:
= TODAY() - DATE( YEAR(), 1, 1)
0

LVL 8

Expert Comment

ID: 39811619
I guess
``````=DATEDIF(DATE(YEAR(TODAY()),1,1),TODAY(),"d")
``````

Thanks
0

LVL 8

Assisted Solution

Naresh Patel earned 1000 total points
ID: 39811621
or as per Mr.Guy Hengel,

``````= TODAY() - DATE( YEAR(TODAY()), 1, 1)
``````

Thanks
``````=DATEDIF(DATE(YEAR(TODAY()),1,1),TODAY(),"d")
``````
0

Author Closing Comment

ID: 39811632
Thanks guys
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…
###### Suggested Courses
Course of the Month11 days, 21 hours left to enroll