| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
company calendar: start date problem
Hi All,
I'm trying to put together a spreadsheet for our company. Part of the set-up requires the entry of our company financial year start date, which is always the second sunday in september. This seems like a fairly simple rule to follow, but i can't think how i can get excel to work it out (either purely by formulae or using vba)... any ideas? Thanks for any guidance, Tim |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
company calendar: start date problem
Try:
=A1-DAY(A1)+15-WEEKDAY(A1-DAY(A1)) A1 contains a date for month e.g. 01/09/2006 HTH "Tim Marsh" wrote: Hi All, I'm trying to put together a spreadsheet for our company. Part of the set-up requires the entry of our company financial year start date, which is always the second sunday in september. This seems like a fairly simple rule to follow, but i can't think how i can get excel to work it out (either purely by formulae or using vba)... any ideas? Thanks for any guidance, Tim |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
company calendar: start date problem
cheers Toppers; i modified it slightly to include the date (in A1) as part
of your formula (with a couple of 'IFs' to work out which side of September your in) - exactly what i needed! Thanks, IDH (it DID help), Tim "Toppers" wrote in message ... Try: =A1-DAY(A1)+15-WEEKDAY(A1-DAY(A1)) A1 contains a date for month e.g. 01/09/2006 HTH "Tim Marsh" wrote: Hi All, I'm trying to put together a spreadsheet for our company. Part of the set-up requires the entry of our company financial year start date, which is always the second sunday in september. This seems like a fairly simple rule to follow, but i can't think how i can get excel to work it out (either purely by formulae or using vba)... any ideas? Thanks for any guidance, Tim |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert date from Gregorian Calendar to Hijri Calendar | Excel Discussion (Misc queries) | |||
| Calculating monthly start date with a start date | Excel Worksheet Functions | |||
| VBA that automatically generates a series of cash flows based on a start date, an end date and frequency | Excel Programming | |||
| Code to bring my company up to date! | Excel Programming | |||
| vba object calendar start date | Excel Programming | |||
Linear Mode
