| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Day of year
Sorry, I wasn't paying enough attention. Type "yy" instead of "yyyy" and it
will give you the last 2 digits of the year -- :) "Dave Peterson" wrote: Huh? <bg JLatham wrote: Yes, as long as both dates are in same year, but if one date was after Feb 29 of a leap year and other year is not leap year... "MartinW" wrote: And following that =TODAY()-DATE(YEAR(TODAY()),1,0) Should work in any year. HTH Martin -- Dave Peterson |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Day of year
Yes it would, but that's still not what the OP asked for, Ruth.
For the 96th day of the year he wanted to see 96, not 07, so he needs =A1-DATE(YEAR(A1),1,0) -- David Biddulph "Ruth" wrote in message ... Sorry, I wasn't paying enough attention. Type "yy" instead of "yyyy" and it will give you the last 2 digits of the year -- :) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combination Graph with current year and prior year sales | Charts and Charting in Excel | |||
| how to calculate $1000/year at 5% for 25 years showing each year | Setting up and Configuration of Excel | |||
| trying to get day/month/year froamt while user enters year only | New Users to Excel | |||
| how do I convert a dates in a year quarters in a year? | Excel Discussion (Misc queries) | |||
| How to compare current year to prior year in bar chart? | Charts and Charting in Excel | |||
Hybrid Mode
