| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
days since 1/1/current year
Is there a formular for days since 1/1/current year
like =weekday(today()) ' day of the week =DAY(today()) ' day of the month =today() ' days since 1/1/1900 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
days since 1/1/current year
=today()-date(year(today()),1,0)
The 0th day of January of this year is Dec 31 of the previous year. dan wrote: Is there a formular for days since 1/1/current year like =weekday(today()) ' day of the week =DAY(today()) ' day of the month =today() ' days since 1/1/1900 -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
days since 1/1/current year
Ps. You may want to subtract 1.
=today() is really the number of days since 12/31/1899 (with Feb 29, 1900 included in the count). Dave Peterson wrote: =today()-date(year(today()),1,0) The 0th day of January of this year is Dec 31 of the previous year. dan wrote: Is there a formular for days since 1/1/current year like =weekday(today()) ' day of the week =DAY(today()) ' day of the month =today() ' days since 1/1/1900 -- Dave Peterson -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
days since 1/1/current year
Hi Dave, Thanks
"Dave Peterson" wrote in message ... =today()-date(year(today()),1,0) The 0th day of January of this year is Dec 31 of the previous year. dan wrote: Is there a formular for days since 1/1/current year like =weekday(today()) ' day of the week =DAY(today()) ' day of the month =today() ' days since 1/1/1900 -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
days since 1/1/current year
won't 2/29/1900 also be included in date(year(today()),1,0)? when evaluating
the difference between two dates, I would think it s/b an issue only if one of those dates is prior to 2/29/1900. "Dave Peterson" wrote: Ps. You may want to subtract 1. =today() is really the number of days since 12/31/1899 (with Feb 29, 1900 included in the count). Dave Peterson wrote: =today()-date(year(today()),1,0) The 0th day of January of this year is Dec 31 of the previous year. dan wrote: Is there a formular for days since 1/1/current year like =weekday(today()) ' day of the week =DAY(today()) ' day of the month =today() ' days since 1/1/1900 -- Dave Peterson -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
days since 1/1/current year
It would.
But I was just trying to address the OP's original statement: =today() ' days since 1/1/1900 JMB wrote: won't 2/29/1900 also be included in date(year(today()),1,0)? when evaluating the difference between two dates, I would think it s/b an issue only if one of those dates is prior to 2/29/1900. "Dave Peterson" wrote: Ps. You may want to subtract 1. =today() is really the number of days since 12/31/1899 (with Feb 29, 1900 included in the count). Dave Peterson wrote: =today()-date(year(today()),1,0) The 0th day of January of this year is Dec 31 of the previous year. dan wrote: Is there a formular for days since 1/1/current year like =weekday(today()) ' day of the week =DAY(today()) ' day of the month =today() ' days since 1/1/1900 -- Dave Peterson -- Dave Peterson -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
days since 1/1/current year
I get it now. Sorry for my misunderstanding.
"Dave Peterson" wrote: It would. But I was just trying to address the OP's original statement: =today() ' days since 1/1/1900 JMB wrote: won't 2/29/1900 also be included in date(year(today()),1,0)? when evaluating the difference between two dates, I would think it s/b an issue only if one of those dates is prior to 2/29/1900. "Dave Peterson" wrote: Ps. You may want to subtract 1. =today() is really the number of days since 12/31/1899 (with Feb 29, 1900 included in the count). Dave Peterson wrote: =today()-date(year(today()),1,0) The 0th day of January of this year is Dec 31 of the previous year. dan wrote: Is there a formular for days since 1/1/current year like =weekday(today()) ' day of the week =DAY(today()) ' day of the month =today() ' days since 1/1/1900 -- Dave Peterson -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Desperately trying to build a paid time off accrual worksheet... | Excel Worksheet Functions | |||
| How can I count amount of Days I worked per year on Excel ? | Excel Worksheet Functions | |||
| Excel NPV initial cost in value1 and first year return in value2? | Excel Worksheet Functions | |||
| Date to Days of the year | Excel Worksheet Functions | |||
| Please help!! Vacation Accrual Formula | Excel Worksheet Functions | |||
Linear Mode
