Solved

Calculate days from beggining of year

Posted on 2014-01-27
4
223 Views
Last Modified: 2014-01-27
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
Comment
Question by:Seamus2626
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 143

Accepted Solution

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

Expert Comment

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

Open in new window



Thanks
0
 
LVL 8

Assisted Solution

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

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

Open in new window


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

Open in new window

0
 

Author Closing Comment

by:Seamus2626
ID: 39811632
Thanks guys
0

Featured Post

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

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

This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

630 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question