Google – Spreadsheets



Data Validation

  • Select Row(Where you want to data Validation)
  • Click inset in tab
  • Click data validation in Insert drop-down Menu,
  • Set your data validation rules
  • Done


Google Sheets: Relative Data Validation with Dynamic Drop Downs

Function : DATEDIF()

How to calculate age from birth of date in Google sheet?

  • Formula : =IF(B2,DATEDIF(B2,TODAY(),"Y"),"")
  • Here
    • IF()  is a if function
    • B2  is the date of birth
    • DATEDIF()  is function return the difference between two dates
      • DATEDIF(start_date,end_date,unit)
    • TODAY()  is a date function it returns the current date of today.
    • Y  is returns year



  • Menu > Tools > Script editor

Image Source

  • By default, it’ll open with a single Google Script file ( and a default code block, myFunction():


Hello World popup box




Image Source




End Of Months

  • EOMONTH(Date(1992,08,1),0)


Sum Specific date

  • =sumifs(Income!F3:F,Income!A3:A,">="&C92,Income!A3:A,"<="&EOMONTH(C92,0))


Sum Specific Criteria

  • =SUMIF(Income!B3:B, B94, Income!F3:F)


Refer Link


Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

if you have any queries call us +918300026060 or WhatsApp Dismiss


Your Cart

%d bloggers like this: