Solved

Calculate days from beggining of year

Posted on 2014-01-27
4
180 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
  • 2
4 Comments
 
LVL 142

Accepted Solution

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

Expert Comment

by:itjockey
Comment Utility
I guess
=DATEDIF(DATE(YEAR(TODAY()),1,1),TODAY(),"d")

Open in new window



Thanks
0
 
LVL 8

Assisted Solution

by:itjockey
itjockey earned 250 total points
Comment Utility
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
Comment Utility
Thanks guys
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

743 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now