Timeline for Is there a formula or function for Numbers that returns the number of days or weeks for a given year
Current License: CC BY-SA 3.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 15, 2016 at 3:01 | answer | added | bjbk | timeline score: 2 | |
| Jan 15, 2016 at 2:06 | comment | added | 0x1801ce | The YEARFRAC function sounds like what I'm looking for. So this will return the number of days, for example July 1 to June 30 and then obviously divide that by 7 to return the weeks. In some formulas I need to use the number of weeks and fortnights in a year which vary with leap-years so I need a function like YEARFRAC by the sounds of it to work out the days and then weeks in the given or current year. | |
| Jan 15, 2016 at 0:34 | comment | added | bjbk | Just to be clear, are you asking how to determine the week number for a given date? By 'return the week in the formula' do you mean the week number? I.e: today 2016-01-14 is in week number 3? Or would this help: "The YEARFRAC function returns the fraction of a year represented by the number of whole days between two dates." | |
| Jan 14, 2016 at 11:10 | history | asked | 0x1801ce | CC BY-SA 3.0 |