Thread: if statement
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.newusers
JE McGimpsey
 
Posts: n/a
Default if statement

TODAY() (not totday). From XL Help ("TODAY"):

TODAY
Returns the serial number of the current date.


For YEAR(), from XL Help ("YEAR"):

YEAR
Returns the year corresponding to a date. The year is returned as an
integer in the range 1900-9999.






In article ,
Sue wrote:

What does "totday" refer to?
I'm guessing "Year" means 2006 (if I am trying to calculate as of this year)