| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Automatically updating insertion of first and last day of year
=IF(A1="Calendar","01/01/" & YEAR(TODAY()),"Value if not Calendar")
"MZ" wrote: I use a drop-down list for choosing between a calendar and fiscal year; if I select "Calendar" in cell A1, what would be a formula for inserting the first day of the year (in cell B1) and last day in the year (in cell B2) that would update each year without having to manually enter the dates 1/1/09 and 12/31/09 in the formula, as shown below: The formula I have now is: (For Cell B1) =IF(A1="Calendar","1/1/2009") -- MZ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a formula which returns the current (updating) year? | Excel Discussion (Misc queries) | |||
| Automatically changing Year | Excel Discussion (Misc queries) | |||
| Why not automatically updating calculations? | Excel Discussion (Misc queries) | |||
| i want to add a column for each day of the year automatically | Excel Discussion (Misc queries) | |||
| Automatically updating | New Users to Excel | |||
Hybrid Mode
